Hello,
I am trying to construct a date from string like
IConv("2004-1-1","yyyymmdd")
This does not seem to work. I am trying to insert this in to a DB2 database table and column is of type 'Date'.
Any help is appreciated.
thanks,
-Anil
Construct a date from a string
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Search this forum for "DB2" and "date" and you'll get to learn all the issues with using the plugin with dates. My apologies in advance...
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The second argument of Oconv() and Iconv() when dealing with dates always begins with "D". It is NOT a date picture.
Bring up on-line help on topic "D" (actually "D Code (BASIC)") for more information, or visit Date Conversion Demystified
Bring up on-line help on topic "D" (actually "D Code (BASIC)") for more information, or visit Date Conversion Demystified
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.