Options
Nominal to Date
Contributor II
Hi,
I have a time stamp field which unfortunately is set as a text field in the DB I am using
I wish to convert this using the "Nominal to Date" Operator but am having some difficulties
An example of a date is 10/23/12 01:19PM
I set the operator to time_stamp and set the time stamp as mm/dd/yy hh:mm
This isn't working
and i suspect its because my understanding of the parsing is a bit on the flawed side
Can anyone help
Thanks in advance
I have a time stamp field which unfortunately is set as a text field in the DB I am using
I wish to convert this using the "Nominal to Date" Operator but am having some difficulties
An example of a date is 10/23/12 01:19PM
I set the operator to time_stamp and set the time stamp as mm/dd/yy hh:mm
This isn't working
and i suspect its because my understanding of the parsing is a bit on the flawed side Can anyone help
Thanks in advance
0
Answers
However, have a look at http://docs.oracle.com/javase/1.4.2/docs/api/java/text/SimpleDateFormat.html for reference and try something like:
MM/dd/yy hh:mma
(not tested, but based on the linked site you will manage to get it right
Best regards,
Marius