Fetch date from timestamp (DB2 Iseries)

asp_crazy_guy · #1 (**permalink**) 01-28-10, 00:21

Hello guys,

Is there any way to fetch only date in the format dd/MM/yyyy from a time stamp field in table from db2 through sql in (V5R4) ?

tonkuma · #2 (**permalink**) 01-28-10, 01:11

CHAR(DATE(timestamp_expression), USA) will return ’mm/dd/yyyy’.

CHAR(DATE(timestamp_expression), EUR) will return ’dd.mm.yyyy’.

REPLACE(CHAR(DATE(timestamp_expression), EUR), '.', '/') will return ’dd/mm/yyyy’.

Please see "DB2 for i5/OS SQL Reference Version 5 Release 4" Chapter 3. Built-in functions.

asp_crazy_guy · #3 (**permalink**) 01-28-10, 02:13

Quote:

Originally Posted by tonkuma

CHAR(DATE(timestamp_expression), USA) will return ’mm/dd/yyyy’.

CHAR(DATE(timestamp_expression), EUR) will return ’dd.mm.yyyy’.

REPLACE(CHAR(DATE(timestamp_expression), EUR), '.', '/') will return ’dd/mm/yyyy’.

Please see "DB2 for i5/OS SQL Reference Version 5 Release 4" Chapter 3. Built-in functions.

Thanks for the reply tonkuma, I cant believe I actually did as you advised

seems like I am catching up lol well thanks for the reference and all the help you do always.
Cheers !

Internet Services

Web Development

Digital Marketing

Consumer Tech