TQL date and time functions
In oracle I can do things like this:
extract(hour from MEASUREMENT_TIMESTAMP),
extract(minute from MEASUREMENT_TIMESTAMP),
extract(year from MEASUREMENT_TimeSTAMP),
extract(month from MEASUREMENT_TimeSTAMP),
extract(day from MEASUREMENT_TimeSTAMP),
however I do not see that functionality with TQL
All I see is this:
You can use the following date functions:
can someone help me simulate how to extract hour, minute, year, month, AM/PM from date_time columns via TQL?
I was able to get PART of the answer by doing this
TQL [database=indot]> select absyear(MEASUREMENT_TIMESTAMP) as YR, absmonth(MEASUREMENT_TIMESTAMP) as MON, absday(MEASUREMENT_TIMESTAMP) as DY from DW_MOBILITY_FACT ;
I understand the year above, but I do NOT understand the absday and absmonth result.
Can someone help me ?Reply