際際滷

際際滷Share a Scribd company logo

Formattime

Download as DOCX, PDF
Y
yclimyingching

FORMATTIME converts a serialized date into a formatted string by expanding various date and time tokens in the provided text. The tokens include elements like $second, $minute, $hour, $day, $month, $year, and $weekday to represent different components of the date. It also includes tokens like $isoweek that represent ISO 8601 week numbers, which can be formatted in multiple ways like $isoweek($year) or $isoweek($year-W$wk).

1 of 1
Download to read offline
FORMATTIME( serial, text ) -- convert a serialized date into a date string The following formatting tokens in text are expanded: Date is assumed to be server time; add GMT to indicate Greenwich time zone. o $second - seconds, 00..59 o $minute - minutes, 00..59 o $hour - hours, 00..23 o $day - day of month, 01..31 o $month - month, 01..12 o $mon - month in text format, Jan..Dec o $year - 4 digit year, 1999 o $ye - 2 digit year, 99 o $wd - day number of the week, 1 for Sunday, 2 for Monday, etc o $wday - day of the week, Sun..Sat o $weekday - day of the week, Sunday..Saturday o $yearday - day of the year, 1..365, or 1..366 in leap years o $isoweek - ISO 8601 week number, one or two digits, 1..53 - Caution: for correct ISO date calculations, specify GMT in the format string or use %FORMATGMTIME%! o $isoweek(format) - formatted ISO 8601 week number. These variables are expanded in format: $isoweek($year) - year of ISO 8601 week number, such as 2009 for 2010-01-03 $isoweek($wk) - 2 digit ISO 8601 week number, such as 53 for 2010-01- 03 $isoweek($day) - day of ISO 8601 week number, starting with 1 for Monday, such as 7 for 2010-01-03 $isoweek($iso) - full year-week ISO week number, such as 2009-W53 for 2010-01-03 $isoweek($yearW$wk$day) - full year-week-day ISO week number, such as 2009W537 for 2010-01-03 $isoweek($year-W$wk-$day) - full year-week-day ISO week number, such as 2009-W53-7 for 2010-01-03 $isoweek($year-W$wk) - year-week ISO 8601 week number, such as 2009-W53 for 2010-01-03

More Related Content

Formattime

  • 1. FORMATTIME( serial, text ) -- convert a serialized date into a date string The following formatting tokens in text are expanded: Date is assumed to be server time; add GMT to indicate Greenwich time zone. o $second - seconds, 00..59 o $minute - minutes, 00..59 o $hour - hours, 00..23 o $day - day of month, 01..31 o $month - month, 01..12 o $mon - month in text format, Jan..Dec o $year - 4 digit year, 1999 o $ye - 2 digit year, 99 o $wd - day number of the week, 1 for Sunday, 2 for Monday, etc o $wday - day of the week, Sun..Sat o $weekday - day of the week, Sunday..Saturday o $yearday - day of the year, 1..365, or 1..366 in leap years o $isoweek - ISO 8601 week number, one or two digits, 1..53 - Caution: for correct ISO date calculations, specify GMT in the format string or use %FORMATGMTIME%! o $isoweek(format) - formatted ISO 8601 week number. These variables are expanded in format: $isoweek($year) - year of ISO 8601 week number, such as 2009 for 2010-01-03 $isoweek($wk) - 2 digit ISO 8601 week number, such as 53 for 2010-01- 03 $isoweek($day) - day of ISO 8601 week number, starting with 1 for Monday, such as 7 for 2010-01-03 $isoweek($iso) - full year-week ISO week number, such as 2009-W53 for 2010-01-03 $isoweek($yearW$wk$day) - full year-week-day ISO week number, such as 2009W537 for 2010-01-03 $isoweek($year-W$wk-$day) - full year-week-day ISO week number, such as 2009-W53-7 for 2010-01-03 $isoweek($year-W$wk) - year-week ISO 8601 week number, such as 2009-W53 for 2010-01-03