Date format

#11

Glad that it helped you!!

Cheers,
Sandeep.

#12

You are right. I agree with you.
My main intention was to show the rich functional capabilities of
non-procedural part of SQL Language, including expresssions and DB2
supplied functions.

Anyway, I found a error in my code.

Quote:

, '%h', SUBSTR(CHAR(QUARTER(ATIMESTAMP)/2),1,1))
is wrong. it should be the following

, '%h', SUBSTR(CHAR((QUARTER(ATIMESTAMP)+1)/2),1,1))

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Date format

comp.databases.ibm-db2 comp.databases.ibm-db2

Re: Date format - 05-25-2006 , 06:15 PM

Re: Date format - 05-26-2006 , 08:30 AM