I have a value of Mar 23 2009 12:00AM on a sequentual file that I need to convert to 20090323 format. I'm wondering what the best approach is. String manipulation or date conversion functions.
Thanks in advance guys.
Datetime on Sequential File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
Re: Datetime on Sequential File
are you writing file to file??? or from file to a DB table???
When you say "on" a sequential file, do you actually mean *in* a sequential file? You won't be able to do pure "string manipulation" as you can't just rearrange the original value to get the desired result. So, hack off the time and then use the normal "date conversion functions" for the rest.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: