Subject Re: DATE VALUE in SQL
From Mervyn Bick <invalid@invalid.invald>
Date Thu, 15 Nov 2018 12:49:41 +0200
Newsgroups dbase.getting-started

On 2018-11-15 11:19 AM, Mustansir Ghor wrote:
> 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
>

Dates in localSQL must be literal values in either American
('dd/mm/yyyy') or German ('dd.mm.yyyy') format irrespective of what the
computers format is set to.

set date American
mdate1=dtoc(date())
set date British
mregno='123456'
mrate=123456
cmd = 'insert into dissales (sdate,item,reg,rate)
values("'+mdate1+'","9B100","'+mregno+'",'+mrate+')'
&cmd.

Mervyn.