• Registered: 2015-10-13
  • Posts: 38

Topic: Formatting time

Hi,

In a SQL statement I can use strftime("%d/%m/%Y",MyDate) for the date is there one for time.

Thanks

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Formatting time

Hello,


Examples:

strftime('%Y-%m-%d', MyDate) 
strftime('%H:%M:%S', MyDate) 
strftime('%Y-%m-%d %H:%M:%S', MyDate)

also

%d          day of month: 00 
 %f          fractional seconds: SS.SSS 
 %H          hour: 00-24 
 %j          day of year: 001-366 
 %J          Julian day number 
 %m          month: 01-12 
 %M          minute: 00-59 
 %s          seconds since 1970-01-01 
 %S          seconds: 00-59 
 %w          day of week 0-6 with Sunday==0 
 %W          week of year: 00-53 
 %Y          year: 0000-9999 
 %%          %
Dmitry.