Subject |
DATE VALUE in SQL |
From |
Mustansir Ghor <mustan31@hotmail.com> |
Date |
Thu, 15 Nov 2018 04:19:03 -0500 |
Newsgroups |
dbase.getting-started |
Dear All
mdate1=dtoc(date())
mregno='123456'
mrate=123456
cmd = 'insert into dissales (sdate,item,reg,rate) values("'+mdate1+'","9B100","'+mregno+'",'+mrate+')'
&cmd.
In the above statement it gives error because of date format. I am using date as british format.
Any suggestion how to go about correcting the statement.
Regards
Mustansir
|
|