| Subject | How do I convert an AM/PM timestamp string? |
|---|---|
| Author | Scott Moon |
| Post date | 2008-02-08T19:47:52Z |
I have a varchar field that stores timestamp data imported from a text
file (CSV). I did not realize until it was too late that the timestamp
data was in AM/PM instead of 24 hour format. I have tried manipulating
the format in Excel to no effect. Does anyone know how to convert a
string timestamp from AM/PM to 24-hour format?
Thanks,
Scott Moon
file (CSV). I did not realize until it was too late that the timestamp
data was in AM/PM instead of 24 hour format. I have tried manipulating
the format in Excel to no effect. Does anyone know how to convert a
string timestamp from AM/PM to 24-hour format?
Thanks,
Scott Moon