Date to the timestamp

cnu · Post by **cnu** » Wed Jul 23, 2008 10:30 am

Hi:

Date is coming like 5/10/2008 from the source.in the target has a column as timestamp .
But my requirement is load the date which is coming from the source 5/10/2008 to the target.Can you let me know how i can transfer in the transformer.

Thanks
cnu

chulett · Post by **chulett** » Wed Jul 23, 2008 11:23 am

What is your target - sequential file, database, what? How is the field defined there? I'm assuming the 'column as timestamp' applies to the DataStage job so we need to clarify how the actual target column is defined.

cnu · Post by **cnu** » Wed Jul 23, 2008 11:41 am

Hi:
Thank for quick response.

Source is Sequential file,target is sybase.
Target column defiend as timestamp.

Thanks
cnu

cnu · Post by **cnu** » Wed Jul 23, 2008 11:41 am

Hi:
Thank for quick response.

Source is Sequential file,target is sybase.
Target column defiend as timestamp.

Thanks
cnu

chulett · Post by **chulett** » Wed Jul 23, 2008 1:07 pm

So now the question is - what does Sybase expect in the way of a Timestamp? The ISO standard YYYY-MM-DD HH24:MI:SS?

cnu · Post by **cnu** » Wed Jul 23, 2008 1:23 pm

Hi:
The problem is resolved.

Thanks
cnu

chulett · Post by **chulett** » Wed Jul 23, 2008 1:43 pm

Well, then it would be great if you could do two things: 1) Post the resolution and 2) Mark the thread as Resolved.

Thanks.