On Oct 20, 2008, at 1:46 PM, jonwood wrote:
>
> Greetings,
>
> Okay, I understand that the designer of SQLite felt it was important
> that
> fields with a default value of CURRENT_DATE should be initialized to
> the
> current date in a DIFFERENT time zone. Setting aside for now that
> I've read
> all the reasons for this and am very much against the decision, I
> have the
> following question.
>
> Is there ANY way to override this behavior? Or must I simply
> initialize all
> such fields explicity if I would like to set it to the current date
> in my
> particular time zone?
CREATE TABLE whatever(
....
timestamp DATE DEFAULT (datetime('now','localtime')),
...
);
>
>
> Thanks.
> --
> View this message in context:
> http://www.nabble.com/CURRENT_DATE-Behavior-tp20075044p20075044.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
