Re: Date to 8 char in SQL

[Peter.Colpaert@xxxxxxxxx]

Matt,

This should do the trick:

select
char((year(current date) * 10000) + (month(current date) * 100) + 
day(current date))
from sysibm.sysdummy1

HTH,

Peter Colpaert
Application Developer
PLI - IT - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----



MWHopkins@xxxxxxxxxxxxxxx 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/09/2007 20:39
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Subject
Date to 8 char in SQL






I'm trying to get a character representation of the current date in sql. I 

can get the date in ISO format, but it has the '-' in it. What is the 
easiest way to get the current date in YYYYMMDD format?

I know that I can do something like:

substr(char(curdate(), iso),1,4) concat substr(char(curdate(), iso),6,2) 
concat substr(char(curdate(), iso),9,2)

There must be a simpler way?! Isn't there?

Matt Hopkins 
Sr. Programmer/Analyst 
Web: www.pdpgroupinc.com 
Email: MWHopkins@xxxxxxxxxxxxxxx 
Office: 410-584-0330 
Fax: 410-584-0336 
Cell: 410-258-8845