DateTime Functions

DATETIME

Returns the exact time stamp in a calendar date specified by the given year , month , day , hour , minute , second , and timezone parts. The second and timezone parts are optional and default to 0 and front-end server time zone, respectively.

DATETIME(year,month, day,hour, minute,[second],[timezone])

where timezone can be either a signed offset (±00:00-23:00) or the letter Z used to represent the UTC time zone (Coordinated Universal Time)

DATETIME(2005,4,23,13,30)

Compiles the exact time stamp in a calendar date according to the given values. In this case, the above example would return 23/4/2005 13:30

DTADD

Increases/decreases a datetime value by the specified number of date or time ( c ) units. The unit part is optional and defaults to 'D' (days).

DTADD (c,n,[unit])

where unit is one of the items listed in the Date Units or Time Units tables

DTADD(@23/4/2009 13:30,4,'D')

Adds 4 days to the value returned. In this case, the above example would be converted to 27/4/2009 13:30

DTGET

Returns the numeric value of the specified date or time ( c ) unit.

DTGET(c,unit)

where unit is one of the items listed in the Date Units or Time Units tables

DTGET(@CREATE_DATETIME,'D')

Returns only the value of the specified date or time unit from within the datetime value. In this case, 23/4/2009 13:30,'D' would return 23 , while 23/4/2009 13:30,'H' would return 13

DTSTR

Converts a datetime object to a formatted string. The format part is optional, and defaults to 'DATETIME'.

DTSTR (c,[format])

where format is devised from the set of special characters listed in the DateTime Formats table

DTSTR(@DATETIME_FIELD,'HH:MI, MON D, YYYY')

Converts the datetime value returned to a string. In this case, 23/4/2009 13:30 would be converted to 13:30, Apr 23, 2009

DTSUB

Returns the difference between two datetime objects, in the specified date or time unit. The unit part is optional and defaults to 'D' (days).

DTSUB (c1,c2,[ unit] )

where unit is one of the items listed in the Date Units or Time Units tables

DTSUB(24/4/2005 14:30, 23/4/2005 13:30,'H')

Calculates the difference in the two datetime objects, specified here, in hours. In this case, the above example would return 25

DTVAL

Converts a string containing a datetime value to a datetime object.

DTVAL(str)

DTVAL(23/4/2009 13:30)

Converts a string containing a datetime value to a datetime object. In this case, the above example would be converted to the datetime object that represents the time stamp 23/04/2009 13:30:00 , in the front-end server's timezone.

DTNOW

Returns the current time stamp in a calendar date.

DTNOW()

DTNOW()

Returns the current time stamp in a calendar date, such as:

27/06/2009 17:04:20