Timestamp comparision
Moderators: chulett, rschirm, roy
Timestamp comparision
Hello all,
I have a timestamp coming as" 2008-10-21 13:14:44.997187"
need to check that 2008 is numeric or not...
Please help me..
I have a timestamp coming as" 2008-10-21 13:14:44.997187"
need to check that 2008 is numeric or not...
Please help me..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Left(Trim(InLink.TheTimestamp),4) Matches "4N"
You can use a mix of Iconv() and Oconv() functions to change the format. Please advise your exact output format requirement.
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What do you want to do with the time component of the timestamp?
What is the data type of the target? Assuming it's a string of some kind, then one answer is
What is the data type of the target? Assuming it's a string of some kind, then one answer is
Code: Select all
Oconv(Iconv(Field(InLink.TheTimestamp, " ", 1, 1), "DYMD"), "DMDY[2,2,4]" : @VM : "MCN")
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: