Hi
I am checking an input coloumn(timestamp),If it is blank
(white spaces),which is not a null value.Then i have to set to 01/01/1800.
input(timestamp) and output stages(date) are DB2
I tried If (input coloumn) = " " then StringToDate('01/01/1800',"%MM/%DD/%YYYY").
Then it is giving an error "APT_CombinedOperatorController(0),0: Data string ' ' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy."
Thanks
Timestamp
Moderators: chulett, rschirm, roy
Re: Timestamp
Hi Ther can anyone tell me how to post a new Question?\
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try if (InputColumn) = '' then 01/01/1800
From your post it is clear that your input is timestamp or blank value, but what is your input datatype , is it Timestamp or string. what is your output datatype Date or Timestamp. Accordingly you can convert it to TimeStampToDate or DateToTimeStamp.
But Why StringToDate ?
From your post it is clear that your input is timestamp or blank value, but what is your input datatype , is it Timestamp or string. what is your output datatype Date or Timestamp. Accordingly you can convert it to TimeStampToDate or DateToTimeStamp.
But Why StringToDate ?
Thanks, BK