Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-09-04 09:16:42
- nardo
- Member
- From: tuvalahiti
- Registered: 2004-04-22
- Posts: 743
what format for article 'date' when inserting into Txp DB?
using asv_tumblelog to insert flickr photos into the Txp database as articles
what format should the date be in?
I currently have:
2009-08-30T13:32:59-08:00
2009-08-30 13:32:59
Either of these good?
Offline
Re: what format for article 'date' when inserting into Txp DB?
Use the second one, see mysql manual on datetime fields
You may have to adjust the time to get the correct timezone. Try inserting one record to see if correction is needed at all.
Offline
#3 2009-09-04 13:11:15
- nardo
- Member
- From: tuvalahiti
- Registered: 2004-04-22
- Posts: 743
Re: what format for article 'date' when inserting into Txp DB?
Thanks, I have it working now … altho to match asv_tumblelog code I had to convert to unix time … and set my Time Zone to Los Angeles (-8) to render actual time of photograph (Sydney, +8)
I know time is a very tricky issue – if zem found it so, I don’t expect to solve anything … my hack is fine for the moment, pleased to get this far!
Offline