Query for Getting the Current Date

Query for Getting the Current Date

Hi Morblack,

You have to pick from these queries to get the current date, time, and timestamp using SQL.

Just pick the ones that will suit your needs.

SELECT current date FROM sysibm.sysdummy1 // mm/dd/yyyy

SELECT current time FROM sysibm.sysdummy1 // hh.mm.ss

SELECT current timestamp FROM sysibm.sysdummy1 // yyyy-mm-dd-hh:mm:ss.ms //milliseconds

Or better off you can do it by directly executing the queries below.

VALUES current date

VALUES current time

VALUES current timestamp

You mean you want to compare a specific time against the date time value from a database record?

You may want to take a look at this link.

I hope it helped.