...
- Source values can be Integer literals or column references to values that can be inferred as Integers.
- If any of the source values are invalid or out of range, a missing value is returned.
- This function must be nested within another function that accepts date values as , such as
DATEFORMAT, as arguments. See the example below.
...
| D code |
|---|
derive type:single value: DATEFORMAT(DATEDATETIME(2015,02,15, 2, 4, 0),'yyyy-MM-dd:HH:mm:ss') |
...
| D code |
|---|
derive type:single value: DATEFORMAT(DATEDATETIME(myYear, myMonth, myDay, myHour, myMin, mySec),'MMM yyyy - HH:MM:SS') |
...
| D code |
|---|
derive type:single value:DATEFORMAT(dateDATETIME(year_integer_col,month_integer_col,day_Integer_col, hour_Integer_col, minute_Integer_col,second_Integer_col),'date_format_string') |
...
