Re: SQL: how to retrieve current date in YYYYMMDD format

[Alan Campin <alan0307d@xxxxxxxxx>]

Do you happen to have iDate, my UDF installed? If yes, it has the
ConvertToiDate that will take a date data type and convert to an
integer which could then be cast to a char field.

select Cast(ConvertToiDate(CURRENT_DATE,'*CCYMD') as Char(8))
from sysibm/sysdummy1

CAST function
  20120808

If not, available at www.think400.dk/downloads.htm under name of iDate.

On Wed, Aug 8, 2012 at 10:56 AM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:
> The following doesn't zero-fill the MM and DD fields.  Is it possible to get SQL to zero-fill these values for months 1 thru 9 and also days 1 thru 9?
>
> YEAR(curDate())   || MONTH(curDate())  ||  DAY(curDate())
>
> Purpose: Im trying to load the current date (20120808) into an old column defined as YYYYMMDD alpha.
>
>
>
> Thanks!
>
>
>
>
> ______________________________________________________________________
> This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.