| Subject | Re: DATE VALUE in SQL |
| From | Mustansir Ghor <mustan31@hotmail.com> |
| Date | Thu, 15 Nov 2018 13:05:35 -0500 |
| Newsgroups | dbase.getting-started |
| Attachment(s) | Capture 1.PNG |
Dear Mervyn Thanks. when I enter in dd/mm/yyyy. it generates error (see attach file). But when I enter in mm/dd/yyyy format it accept it. Example insert into dissales (sdate) values("11/15/2018") Pls can try this. May be there is something I am missing. Regards Mustansir Mervyn Bick Wrote: > 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. | |