time_t

[Nathan Buchanan]

On Tue, Jul 15, 2008 at 2:30 PM, Nathan Buchanan <nbinont at gmail.com> wrote:

>
> On Tue, Jul 15, 2008 at 1:43 PM, Phil Longstaff <plongstaff at rogers.com>
> wrote:
>
>> Derek Atkins wrote:
>> > Quoting Phil Longstaff <plongstaff at rogers.com>:
>> >
>> >> Different database engines have different column types for storing
>> >> dates/times, so I'm using a 'YYYYMMDDHHMMSS' char string.
>> >
>> > ... in what timezone?    Do you always convert to UTC?
>> >
>> >> Phil
>> >
>> > -derek
>> >
>>
>> ... converted to UTC
>
>
> (as you already have something, please feel free to ignore me...) You could
> also use ANSI SQL timstamps, and let the database worry about the storage.
>

Seems I spoke to soon...apparently sqlite doesn't support timestamp data
type columns. Seems I have a habit of assuming to much of the
database...sigh.

Nathan

>
>
> Nathan
>
>>
>>
>> Phil
>>
>> _______________________________________________
>> gnucash-devel mailing list
>> gnucash-devel at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>
>
>
>
> --
> <><><><><><><><><><><><><><><>
> "Even if you are on the right track, you'll get run over if you just sit
> there" - Will Rogers
>



-- 
<><><><><><><><><><><><><><><>
"Even if you are on the right track, you'll get run over if you just sit
there" - Will Rogers