Q&A BY TAG 'Date time function'

Hello Team I want my hours to be return in 24 hour format and not in the AM/PM format. for exemple, now, i have this kind of hour 03:38:00, and i would prefer 15:38:00. Is there a function that can change it in the output? Thanks

Date time function

Hi Team, Denodo 7.0 column 1: 2024-07-01 01:00:00 column 2: 2024-07-30 02:00:00 format is yyyy-mm-dd time is in AM data type is text operation to perform = column 1 - column 2 expected result = 2509200 seconds how to acheive this above re...

Date time function

Hi! I need to query HTTP/JSON datasource with parameters like this: /values?Name=Foobar&Start=2024-01-16&End=2024-01-17 (the previous and the current days) so I create a Base view with relative URL like this: /values?Name=Foobar&Start=@...

JSON HTTP client Date time function

Hi I'd like to query the teradata query in denodo VQL, however I cant able to get the syntax right. SELECT ADDMONTH(ADDMONTH(CURRENT_DATE, -12), (EXTRACT(MONTH FROM ADDDAY(<field_name> , -12 ) -6 ))) Any pointers would be appreciated. Thank you.

Date Conversion Dynamic Dates Date time function

I have a field with data type odf text that returns value in the format : '2021-01-10T07:04:38Z' How can I convert it to locale specific date format so that I can perform date operation on it??

Date Conversion to_timestamp Date time function

Hello, Is there any possibility to achieve in Denodo something similar to NUMTODSINTERVAL Oracle function? select NUMTODSINTERVAL(0.6, 'DAY') from dual; Thank you in advance!

Date time function

I have a data source which requres a dynanmic file name to be reference using a Julian date - last two digits of the year and the current day number. So 2022-04-04 would be 22094. Is there an easy way to include this value as part of the interpolatio...

Formula Interpolation Variables Date time function

We recently started using a Postgres connection in Denodo. We've noticed that on larger datasets (particularly in joins) that performance is impacted when using the ADDMONTH function. ADDMONTH can't be delegated to the data source since it's not a Post...

datetime PostgreSQL Date time function

Hello, I know that I can get the current timestamp using the currenttimestamp function. I wanted to know what is the right way to subtract 24 hours from the timestamp returned from that function, in order to find the timestamp of exactly 24 hours befo...

local timestamp Date time function WHERE CONDITIONS timestamp

I have below string output using Formatdate function applied 08/03/2017 04:48:34 PM How to remove leading zeros O/p - 8/3/2017 4:46:34 PM Please help

Date time function