D. Richard Hipp wrote: > > The date & time come out in an easily parseable format: YYYY-MM-DD > HH:MM:SS. So you call: > > sscanf(zDateStr, "%d-%d-%d %d:%d:%d", &y, &m, &d, &H, &M, &S); > sprintf(zNewDate, "%d/%d/%d %d:%d%s", m, d, y%100, (H-1)%12+1, M, > H>=12 ? "pm" : "am"); > > Is that really so hard? >
I don't recall anyone saying anything about being hard. It's a design/efficiency issue. I may do what you suggest only because there is code in place already that uses a DATETIME column. But in the future I think I'd recommend storing my own integer date format, as others here have suggested. Thanks. Jonathan -- View this message in context: http://www.nabble.com/DateTime-Objects-tp22264879p22268698.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
