getting current time in SQL

smith43017 · #1 (**permalink**) 11-09-07, 11:21

How can we get current time stamp along with rest of SQl values.

Ex:

Time col1 col2 col3

timestamp abc 243920842 kclsjd
timestamp dsfd 324343335 fghfdf

smith43017 · #2 (**permalink**) 11-09-07, 11:37

please some body can help me out???

smith43017 · #3 (**permalink**) 11-09-07, 11:48

got it

-- Date
SELECT current date
FROM sysibm.sysdummy1;

-- Time
SELECT current time
FROM sysibm.sysdummy1;

-- Date-Time
SELECT current timestamp
FROM sysibm.sysdummy1

smith43017 · #4 (**permalink**) 11-09-07, 11:49

select current timestamp ,rtrim(tabname),card from sysibm.sysdummy1 a,syscat.tables b where b.tabname in ('t1_OLD','t2_OLD');

stolze · #5 (**permalink**) 11-09-07, 12:14

Remove the bogus "sysibm.sysdummy1" from your query. This join doesn't do anything in your case.

Code:

SELECT current timestamp AS timestamp,
       RTRIM(tabname) AS table_name,
       card
FROM   syscat.tables
WHERE  tabname IN ( 't1_OLD', 't2_OLD' )

Note that table names in the catalog views (like SYSCAT.TABLES) are case-sensitive. You must have used delimited identifiers in the table for you query to work, i.e.

Code:

CREATE TABLE "t1_OLD" ( ... )

Internet Services

Web Development

Digital Marketing

Consumer Tech