You are viewing the documentation for Blueriq 15. Documentation for other versions is available in our documentation directory.

DATETIME


Creates a dateTime value out of integers.


Numbers will be rounded to integers.
There is also a conversion function DATETIME.


Syntax

DATETIME ( year , month , day , hour , minute , second )



Inputs
  • year - An integer value between and including 1 and 9999 that represents the year in the constructed date.
  • month - An integer value between and including 1 and 12 that represents the month in the constructed date.
  • day - An integer value between and including 1 and 31 that represents the day in the constructed date.
  • hour - An integer value between and including 0 and 23 that represents the hours in the constructed time.
  • minute - An integer value between and including 0 and 59 that represents the minutes in the constructed time.
  • second - An integer value between and including 0 and 59 that represents the seconds in the constructed time.


Return type

  • dateTime


Examples

ExpressionResultType
DATETIME ( 2010 , 5 , 25 , 23 , 00 , 00 )25-5-2010 23:00:00DateTime
DATETIME ( -2010 , 5 , 25 , 23 , 00 , 00 )UNKNOWNDateTime
DATETIME ( 2010 , 5 , 25 , 45 , 00 , 00 )UNKNOWNDateTime


Back to Top