Q&A BY TAG 'Date time function'

You must sign in to ask a question. If you do not have an account, you can register here

Postgres ADDDAY translates, but other ADD datetime functions do not
answered 20-05-2021 21:10:43 -0400

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...

Answers: 3

datetime PostgreSQL Date time function

Timestamp From 24 Hours Ago of Current Timestamp
answered 05-03-2021 00:47:13 -0500

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...

Answers: 1

local timestamp Date time function WHERE CONDITIONS timestamp

How to remove leading zero's in date time stamp
answered 29-09-2020 05:57:13 -0400

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

Answers: 1

Date time function