STRFTIME()

Syntax

STRFTIME(<expC1> [, <expC2> ])

See Also

AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), ELAPTIME(), EMPTY(), EPOCH(), GOMONTH(), HOUR(), HOURS(), LTOS(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), MTOS(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, SET VAXTIME, STOD(), STR(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), VTOD(), WEEK(), YEAR()

Description

<expC1> is a string which may include any of the format elements from the table below. The optional <expC2> is a date or datetime in string format. If <expC2> is not specified, the current system date and time are assumed.

Format Element	Description	Example value
Day
%a	Abbreviated character day of the week	Sun - Sat
%A	Character day of the week	Sunday - Saturday
%d	Day of the month (two digits with leading zero)	01 to 31
%e	Day of the month (space precedes single digits)	1 - 31
%j	Day of the year (three digits with leading zeros)	001 - 366
%u	ISO-8601 numeric day of the week	1 (Monday) - 7 (Sunday)
%w	Numeric day of the week	0 (Sunday) - 6 (Saturday)
Week
%U	Week of the year: week 01 starts from the first Sunday	00 - 53
%V	ISO-8601 week of the year: week 01 is the first week with at least 4 weekdays, Monday start	01 to 53
%W	Week of the year: week 01 starts from the first Monday	00 - 53
Month
%b	Abbreviated month	Jan - Dec
%B	Month	January - December
%h	Abbreviated month	Jan - Dec
%m	Month (two digits with leading zero)	01 to 12
Year
%C
%g
%G
%y
%Y
Time
%H
%I
%l
%M
%p
%P
%r
%R
%S
%T
%X
%z
%Z
Time and Date Stamps
%c
%D
%F
%s
%x
Miscellaneous
%n%D
%t%D
%%%D%%%n%n

Products

Recital, Recital Server