Convert Statement in db2

vivek.vivek · #1 (**permalink**) 02-02-09, 07:50

Plese help me to convert this to db2.
The statement is in SQL.

select convert(varchar(50),getdate(),1) +' '+cast(convert(varchar(50),getdate(),8) as varchar(5)) as d1

Thanks in Advance,
Vivek Kumar

r937 · #2 (**permalink**) 02-02-09, 08:26

the effect of this monstrously inefficient SQL Server (not SQL) expression is to truncate the current datetime to the nearest earlier whole minute

so 2009-02-02 09:37:21 becomes 2009-02-02 09:37:00

does that help?

stolze · #3 (**permalink**) 02-02-09, 09:35

Code:

VALUES CURRENT TIMESTAMP - SECONDS(CURRENT TIMESTAMP) SECONDS

sathyaram_s · #4 (**permalink**) 02-02-09, 09:49

Building on Knut's solution :

Code:

VALUES (CURRENT TIMESTAMP - SECOND(CURRENT TIMESTAMP) SECONDS - MICROSECOND(CURRENT TIMESTAMP) MICROSECONDS )

hkp819 · #5 (**permalink**) 02-03-09, 00:22

Hope that will help you:...
Problem with synta of SQL statement in DB2 SP : IBM DB2, Sql statement

r937 · #6 (**permalink**) 02-03-09, 00:55

once again, hkp819, i feel compelled to ask you "wtf???"

stolze · #7 (**permalink**) 02-03-09, 07:12

I think this is cool... a website with a badly formatted SQL statement and no one has any idea how it relates to the current thread. :-)

Internet Services

Web Development

Digital Marketing

Consumer Tech