Subject Re: DATE format From Mustansir Ghor <mustan31@hotmail.com> Date Thu, 05 Nov 2020 02:46:15 -0500 Newsgroups dbase.getting-started Thank You Mervyn sir and Gaetano Regards Mustansir Gaetano Wrote: > > > Hi Mustansir, > > There is unfortunately no DTTOS() (DateTimeToString) function in dBase. > You can either temporarily change the format as Mervyn suggested, > however, you may need to store the Mark setting (i.e. date separator - > cMark = set('Mark')) to reset it when switching back to your local > format as I believe that dBase uses the "-" mark by default when > switching formats), or you can try this function I wrote to produce the > format you are looking for. > > function DTTOS(dDT) > /* must supply dateTime value, e.g. from a dBase Timestamp field or > {literal datetime} in valid local format, a date object or the datetime > function > > Usage: > ?dttos(datetime()) > ?dttos({14/1/2020 14:00:00}) > ?dttos(oRowset.fields["transactionTimeStamp"].value) > > form.entryField1.value = dttos(oRowset.fields["transactionTimeStamp"].value) > > */ > >     local dDate,tTime,cRet >     dDate = substr(DTOS(dDT),1,4)+"-"+substr(DTOS(dDT),5,2)+                  >         "-"+substr(DTOS(dDT),7,2) >     tTime = TTOC(dDT) >     cRet = dDate+" "+tTime > return cRet > > > Cheers, > Gaetano. > > On 05/11/2020 03:40, Mervyn Bick wrote: > > On 2020/11/04 18:25, Mustansir Ghor wrote: > >> Dear All > >> > >> I wish to get format of datetime() function to display YYYY-MM-DD > >> HH:MM:SS. > >> > >> Can anybody advise how this can be achieved > >> > >> Best Regards > >> Mustansir > >> > > > > With the date set to YMD datetime() displays YYYY-MM-DD HH:MM:SS > > > > dBASE 2109 with Windows 10 Pro, 64-bit, version 2004. > > > > See attached screenprint. > > > > Mervyn. >