Date Conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 25
- Joined: Mon Sep 19, 2005 11:32 am
Date Conversion
hi,,
i have got a query where in i will get date and timestamp like
12/10/2005 11:20:21
i need to transform that into two colums in the next stage with date and time as a seperate columns.
help is appreciated
thanks
i have got a query where in i will get date and timestamp like
12/10/2005 11:20:21
i need to transform that into two colums in the next stage with date and time as a seperate columns.
help is appreciated
thanks
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DateFromTimestamp() and TimeFromTimestamp() functions seem to be the obvious candidates. You will need a format string if your timestamp does not correspond to your project's default format.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 25
- Joined: Mon Sep 19, 2005 11:32 am
thanks for ur reply ray,,but i dont have DateFromTimestamp() in my DS7.5.1,, can you please explain more as i am very new to DSray.wurlod wrote:DateFromTimestamp() and TimeFromTimestamp() functions seem to be the obvious candidates. You will need a format string if your timestamp does not correspond to your project's default format. ...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 25
- Joined: Mon Sep 19, 2005 11:32 am
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Sorry, could you be clear on what you need?thatiprashant wrote:thanks for ur reply,,i found timestamptodate function and when i am trying to use it it gives timestamp qoute,,can you pls help me wat to enter in thatray.wurlod wrote:You do have it. Use the Expression Editor in a Transformer stage. It will appear in among the available Functions. ...
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 25
- Joined: Mon Sep 19, 2005 11:32 am
thanks for the reply sam,, i did try that but it just gives the date as ******us1aslam1us wrote:Hi Thati,
That will do the job.Code: Select all
TimestampToTime(DSLink3.columnname)
Sam
and time rounded as 0 like 00:00:00
help on this wud be apreciated.
thanks
-
- Participant
- Posts: 25
- Joined: Mon Sep 19, 2005 11:32 am
-
- Participant
- Posts: 25
- Joined: Mon Sep 19, 2005 11:32 am