On Feb 28, 2009, at 6:16 PM, jonwood wrote:
>
> Yeah, I can do parsing with existing column.
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?
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
