Thursday, September 13, 2012

DATE/TIME BUILT IN FUCNCTIONS


DATEReturns the current date in the pattern YYMMDD
DATETIMEReturns the current date and time in the user-specified pattern or in the default pattern YYYYMMDDHHMISS999
DAYSReturns the number of days corresponding to a date/time pattern string, or the number of days for today's date
DAYSTODATEConverts a number of days to a date/time pattern string
DAYSTOSECSConverts a number of days to a number of seconds
REPATTERNTakes a value holding a date in one pattern and returns that value converted to a date in a second pattern
SECSReturns the number of seconds corresponding to a date/time pattern string, or the number of seconds for today's date
SECSTODATEConverts a number of seconds to a date/time pattern string
SECSTODAYSConverts a number of seconds to a number of days
TIMEReturns the current time in the pattern HHMISS999
VALIDDATEIndicates if a string holds a valid date
WEEKDAYReturns the day of the week corresponding to the current day or specified DAYS value
Y4DATETakes a date value with the pattern 'YYMMDD' and returns the date value with the two-digit year widened to a four-digit year
Y4JULIANTakes a date value with the pattern 'YYDDD' and returns the date value with the two-digit year widened to a four-digit year
Y4YEARTakes a date value with the pattern 'YY' and returns the date value with the two-digit year widened to a four-digit year