×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Set old_field = YEAR(curDate()) || substr('00',1,length(trim(MONTH(curDate())))) || MONTH(curDate()) ||
substr('00',1,length(trim(DAY(curDate())))) || DAY(curDate());
Steve Needles
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Wednesday, August 08, 2012 11:56 AM
To: 'Midrange Systems Technical Discussion'
Subject: SQL: how to retrieve current date in YYYYMMDD format
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
______________________________________________________________________
midrange.com
