Re: How to convert date in SQL

To return a character field do this...

substr(char(FILEDATE),5,2) + '/' + substr(char(FILEDATE),7,2) + '/' +
substr(char(FILE),1,4)                        

If you would like the field to be a date you can use...

date(substr(char(FILEDATE),5,2) + '/' + substr(char(FILEDATE),7,2) +
'/' + substr(char(FILE),1,4))
                        



>>> mahesh@xxxxxxxxxxxx 11/07/03 08:33AM >>>
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.