Formatting dates question

rdy · Post by **rdy** » Tue Jan 10, 2006 3:25 pm

Anyone know the code to turn a Timestamp that looks like this:

2005-05-29

Into this:

2005-05-29 00:00:00.000

jzparad · Post by **jzparad** » Tue Jan 10, 2006 3:29 pm

Isn't this just a string concatenation?

rdy · Post by **rdy** » Tue Jan 10, 2006 3:31 pm

jzparad wrote:Isn't this just a string concatenation?

Well I was trying to actually get the time portion. If you mean just concatenating the string '00:00:00.000' in this example, that wouldn't fit the requirements.

(Guess I need to be more specific :D

kcbland · Post by **kcbland** » Tue Jan 10, 2006 3:54 pm

There are no time elements to dates as Server has no data typing enforced, everything is a string. Therefore, any value of 2005-12-31 is just a text string inside DataStage.

If you're asking from an SQL perspective, I suggest you specify in your SQL the format of date/time values. In Oracle, it would be to_char(yourdate, "YYYY-MM-DD HH24:MI:SS")