Date to timestamp format

Sxvank · #1 (**permalink**) 11-16-09, 18:03

Experts,

I want to change the date to timestamp format in db2 udb datbase table which is running in V8.1 , Please provide me
best possible solution .Its urgent. Please help

thanks in advance,

rahul_s80 · #2 (**permalink**) 11-17-09, 00:13

timestamp_iso

Mathew_paul · #3 (**permalink**) 11-17-09, 01:26

select timestamp(colname,'00.00.00') from tbname

regds
Paul

Lenny77 · #4 (**permalink**) 11-17-09, 10:08

...timestamp(date(col1), current time)...

example:

Quote:

select timestamp(current date, current time) from sysibm.sysdummy1

Lenny

tonkuma · #5 (**permalink**) 11-17-09, 12:10

timestamp_iso may be the simplest. But, the schema is SYSFUN.

DB2 UDB SQL Reference Volume 1 Version 8.2
Chapter 3. Functions

Quote:

Functions overview

Built-in functions are provided with the database manager; they return a single
result value, and are identified as part of the SYSIBM schema. Built-in functions
include column functions (such as AVG), operator functions (such as “+”), casting
functions (such as DECIMAL), and others (such as SUBSTR).

User-defined functions are registered to a database in SYSCAT.ROUTINES (using the
CREATE FUNCTION statement). User-defined functions are never part of the
SYSIBM schema. One such set of functions is provided with the database manager
in a schema called SYSFUN, and another in a schema called SYSPROC.

Internet Services

Web Development

Digital Marketing

Consumer Tech