|
Thanks Rob Always looking for more than one way to "skin a cat" Gord -----Original Message----- From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] Sent: Friday, November 07, 2003 2:49 PM To: RPG programming on the AS400 / iSeries Subject: RE: How to convert date in SQL Although I'd strongly suggest that you stay away from using the vertical bars for concatenation, especially if multilingual support may be on your horizon. select case when clast=0 then date('0001-01-01') else date( substring(char(clast),1,4) concat '-' concat substring(char(clast),5,2) concat '-' concat substring(char(clast),7,2)) end as Date_Formatted, clast from dhtheif/rcm DATE_FORMATTED Last Transaction Date 2003-05-02 20,030,502 0001-01-01 0 Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin Gord Royle <GRoyle@xxxxxxxx> Sent by: rpg400-l-bounces@xxxxxxxxxxxx 11/07/2003 02:20 PM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> To "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx> cc Subject RE: How to convert date in SQL Sounds like you're a BPCS user where all of the dates are stored as numbers. You have to jump through hoops. Something like. select date(substring(Char(LHDATE),1,4) || '-' || substring(Char(LHDATE),5,2) || '-' || substring(Char(LHDATE),7,2)) as Date_Formatted from "PRDBPCS"."PRODF"."GLH" T1 Gord Royle -----Original Message----- From: Mahesh Pawar [mailto:mahesh@xxxxxxxxxxxx] Sent: Friday, November 07, 2003 9:33 AM To: RPG programming on the AS400 / iSeries Subject: How to convert date in SQL Hello all, I want to display database date (yyyymmdd) in mm/dd/yyyy format. how to achive this in SQL query Thanks & Regards Mahesh Pawar Project Manager System & Software, SDF IV,Unit 123, Seepz, Mumbai, India. Phone# : 0091-22-28290075,28291824 Fax #: 0091-22-28292578(Fax) Visit us on :www.systsoft.com -------------------------------------------------------------- Systems & Software, Mumbai, India Sent using PostMaster by QuantumLink Communications Pvt Ltd One Internet account, unlimited personal e-mail addresses Get your free copy of PostMaster at http://www.postmaster.co.in/ _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.