On Mon, Sep 1, 2008 at 10:29 PM, Derrell Lipman <
[EMAIL PROTECTED]> wrote:
>
>
> On Mon, Sep 1, 2008 at 10:16 PM, jonwood <[EMAIL PROTECTED]> wrote:
>
>>
>> Okay, I give up. I've been searching for a while now. I've found a number
>> of
>> discussions about how CURRENT_DATE returns the date in
On 9/1/08, jonwood <[EMAIL PROTECTED]> wrote:
>
>
> P Kishor-3 wrote:
> >
> > Don't think it is possible. As you noted, the docs say very clearly
> > (http://www.sqlite.org/lang_createtable.html) -- " The DEFAULT
> > constraint specifies a default value to use when doing an INSERT. ..
> >
P Kishor-3 wrote:
>
> Don't think it is possible. As you noted, the docs say very clearly
> (http://www.sqlite.org/lang_createtable.html) -- " The DEFAULT
> constraint specifies a default value to use when doing an INSERT. ..
> default value may also be one of the special case-independant
Derrell Lipman wrote:
>
> I think this is the page you're looking for:
> http://www.sqlite.org/lang_datefunc.html
>
> In particular, a query that returns the current time in the local (to
> sqlite) time zone is:
>SELECT datetime('now', 'localtime');
> or for just the date:
>SELECT
On 9/1/08, jonwood <[EMAIL PROTECTED]> wrote:
>
> Okay, I give up. I've been searching for a while now. I've found a number of
> discussions about how CURRENT_DATE returns the date in UTC, and that it can
> be converted to local time. But I've yet to find one article that clearly
> states how
On Mon, Sep 1, 2008 at 10:16 PM, jonwood <[EMAIL PROTECTED]> wrote:
>
> Okay, I give up. I've been searching for a while now. I've found a number
> of
> discussions about how CURRENT_DATE returns the date in UTC, and that it can
> be converted to local time. But I've yet to find one article that
Okay, I give up. I've been searching for a while now. I've found a number of
discussions about how CURRENT_DATE returns the date in UTC, and that it can
be converted to local time. But I've yet to find one article that clearly
states how one might do this.
I would love to have a table column
7 matches
Mail list logo
