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