I have a field in my database of type DateTime but i configure it to be just a time like that 10:00 .
Now i wanna to accept the time in the format like that :
10:00 AM or 10:00 PM ..
Asked
Active
Viewed 166 times
1
Anyname Donotcare
- 10,649
- 59
- 212
- 375
-
I try to insert time like `10:00 AM` in a field of type Datetime .informix database – Anyname Donotcare Dec 04 '12 at 12:23
-
2Why not use 24 hour notation instead? `10:00` and `22:00`? – Oded Dec 04 '12 at 12:23
-
the user prefer the previous notation – Anyname Donotcare Dec 04 '12 at 12:24
-
http://stackoverflow.com/questions/2596969/why-cant-datetime-parseexact-parse-the-am-pm-in-4-4-2010-42000-pm-using – Phil Gan Dec 04 '12 at 12:32
1 Answers
1
- Get the all
DateTimein your query - Use IF for your field
Use syntax like
If (Hours of Datetime > 12) Then Hours of Datetime - 12 + "PM"
I agree this is little bir confused but this is the structure you should follow.
Soner Gönül
- 94,086
- 102
- 195
- 339