Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > db2 > answers

convert 'Apr 19 20:00:03 CDT 2009' string to date

Newbie
  
Join Date: May 2009
Posts: 2
#1: May 19 '09
hi ,

i am unable to convert'Apr 19 20:00:03 CDT 2009' which is a string to a valid date format plz let me know the function

Newbie
  
Join Date: Jul 2009
Location: India
Posts: 2
#2: Jul 18 '09

re: convert 'Apr 19 20:00:03 CDT 2009' string to date

Try this... but I am not sure whether it will work....
select date('Apr 19 20:00:03 CDT 2009')
from sysibm.sysdummy1
docdiesel's Avatar
Moderator
  
Join Date: Aug 2007
Location: Munich
Posts: 289
#3: Jul 21 '09

re: convert 'Apr 19 20:00:03 CDT 2009' string to date

Hi,

that won't do. The string must be in one of the following formats:
  • "2009-06-25-16.12.30.000000"
  • "2009-06-25"
  • "25-06-2009"
Try to chop and rearrange the string by using substr() and maybe replace() for the month' name.

Regards


Doc
Reply

« previous question | next question »

Similar DB2 Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved