CODEWITHSUNDEEP
djangodatetime
itcropper
itcropper

Reputation: 772

Whats the correct format for django dateTime?

Im writting an app, and im using a datetime selector to allow users to select a date and time. After some formatting in javascript, im left with a dateTime like this:

2012-09-04 06:00 PM

and django throws and error saying:

[u"'2012-09-04 06:00 PM' value has an invalid format. It must be in YYYY-MM-DD HH:MM[:ss[.uuuuuu]][TZ] format."]

Ive also tried 

2012-09-04 06:00PM
2012-09-04 06:00 P.M.
2012-09-04 06:00P.M.

but no luck. Can anyone see what Im doing here? Or know what django is looking for (in English)?

Upvotes: 17

Views: 37515

Answers (3)

Ahmed Adewale
Ahmed Adewale

Reputation: 3133

I used this'2012-09-04 06:00:00.000000-08:00' and it worked perfectly

Upvotes: 1

itcropper
itcropper

Reputation: 772

After talking around, what I figured out is that there is no AM/PM input. I had to just check if my dateTimePicker was returning an AM or PM suffix, then call time.split(":"); to break up hours and minutes, convert the hours to int from a string, then add 12 to it to convert the time to 24 hour time instead of 12 hour time. Theirs probably an easier way to do it, but thats what worked for me.

For example:

2012-09-04 06:00 PM

Needs to be

2012-09-04 18:00

Upvotes: 3

okm
okm

Reputation: 23871

As said by the error msg, it expects YYYY-MM-DD HH:MM[:ss[.uuuuuu]][TZ], thus following are valid values:

2012-09-04 06:00
2012-09-04 06:00:00
2012-09-04 06:00:00.000000

# w/ optional TZ as timezone. 
2012-09-04 06:00Z # utc
2012-09-04 06:00:00+0800
2012-09-04 06:00:00.000000-08:00

Upvotes: 51

Related Questions