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
My Visual Database → Script → Formatting time
Hi,
In a SQL statement I can use strftime("%d/%m/%Y",MyDate) for the date is there one for time.
Thanks
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
%% %
My Visual Database → Script → Formatting time
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi