IT315_DATE_FORMATS.docx

Sr.No. Specifier & Description 1 **%a** Abbreviated weekday name (Sun..Sat) 2 **%b** Abbreviated month name (Jan..Dec) 3 **%c** Month, numeric (0..12) 4 **%D** Day of the month with English suffix (0th, 1st, 2nd, 3rd,.) 5 **%d** Day of the month, numeric (00..31) 6 **%e** Day of t...

Sr.No. Specifier & Description 1 **%a** Abbreviated weekday name (Sun..Sat) 2 **%b** Abbreviated month name (Jan..Dec) 3 **%c** Month, numeric (0..12) 4 **%D** Day of the month with English suffix (0th, 1st, 2nd, 3rd,.) 5 **%d** Day of the month, numeric (00..31) 6 **%e** Day of the month, numeric (0..31) 7 **%f** Microseconds (000000..999999) 8 **%H** Hour (00..23) 9 **%h** Hour (01..12) 10 **%I** Hour (01..12) 11 **%i** Minutes, numeric (00..59) 12 **%j** Day of year (001..366) 13 **%k** Hour (0..23) 14 **%l** Hour (1..12) 15 **%M** Month name (January..December) 16 **%m** Month, numeric (00..12) 17 **%p** AM or PM 18 **%r** Time, 12-hour (hh:mm:ss followed by AM or PM) 19 **%S** Seconds (00..59) 20 **%s** Seconds (00..59) 21 **%T** Time, 24-hour (hh:mm:ss) 22 **%U** Week (00..53), where Sunday is the first day of the week 23 **%u** Week (00..53), where Monday is the first day of the week 24 **%V** Week (01..53), where Sunday is the first day of the week; used with %X 25 **%v** Week (01..53), where Monday is the first day of the week; used with %x 26 **%W** Weekday name (Sunday..Saturday) 27 **%w** Day of the week (0=Sunday..6=Saturday) 28 **%X** Year for the week where Sunday is the first day of the week, numeric, four digits; used with %V 29 **%x** Year for the week, where Monday is the first day of the week, numeric, four digits; used with %v 30 **%Y** Year, numeric, four digits 31 **%y** Year, numeric (two digits) 32 **%%** A literal.%. character 33 **%x** x, for any.x. not listed above DATE FUNCTIONS --------------