How to combine date and time into a timestamp in db2?

sql date time db2 timestamp
xan picture xan · Mar 1, 2013 · Viewed 27k times · Source

In a db2 database I have a DATE column and a TIME column, how can you combine these into a single TIMESTAMP?

Answer

user1919238 picture user1919238 · Mar 1, 2013

The timestamp function can be called with two arguments, one of which is date and one of which is time:

select timestamp(date_col,time_col) from your_table

Related questions

Difference between datetime and timestamp in sqlserver?

What is the difference between Timestamp and Datetime SQL Server? I thought Both formats are capable of storing date + time. Then, Where the difference is lying between them? But Timestamp is not capable of storing date, time information. Still Whats …

Read More
Mysql Datediff query

I need to get the result from the table, which the date should be difference of 5 from the current date. ie., specific_date column is present in my table. The format of the date is YYYY-MM-DD. I need the query …

Read More
Generate interval from variable in Presto

In Presto SQL, unlike regular SQL, intervals must be created with inverted commas: INTERVAL '1' DAY rather than INTERVAL 1 DAY I am trying to generate a set of dates as described here: https://stackoverflow.com/a/2157776/2388930, but am encountering …

Read More