Anyone know the code to turn a Timestamp that looks like this:
2005-05-29
Into this:
2005-05-29 00:00:00.000
Formatting dates question
Moderators: chulett, rschirm, roy
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")
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")
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