Datetime on Sequential File

kld05 · Post by **kld05** » Wed Mar 25, 2009 4:21 pm

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.

Kryt0n · Post by **Kryt0n** » Wed Mar 25, 2009 4:43 pm

Unless DS has been messing me around, you can't do date manipulation unless the field is in the date format specified by your project, which I suspect will require string manipulation first...

Of course, if your project specifies date format as MMM DD YYYY then I guess you are already halfway there

betterthanever · Post by **betterthanever** » Wed Mar 25, 2009 5:32 pm

are you writing file to file??? or from file to a DB table???

chulett · Post by **chulett** » Wed Mar 25, 2009 6:55 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 25, 2009 8:51 pm

Conversion functions StringToTimestamp(), TimestampToDate() and DateToString() should do it.

DSXchange

Datetime on Sequential File

Datetime on Sequential File

Re: Datetime on Sequential File