Re: [cobalt-developers] OT: Interbase CURRENT_TIMESTAMP problems...

["Edgar F. Flores Muñoz" <ed@xxxxxxxx>]

I use interbase with TIMESTAMP datatype, and I use it by this way

create table TABLE (
id integer,
date TIMESTAMP default 'NOW'
);

And all dates is OK with their time.

At 11:04 25/03/2002 +0000, you wrote:
> Hi folks,
>
> Has anyone experienced date problems with Interbase 6 (RaQ4i)?
>
> I have created a field (datatype TIMESTAMP) with a default value of
> CURRENT_TIMESTAMP. When creating a new row from the web interface the date
> appears as 1858-11-17 00:00:00.0000, however (apart from the time missing)
> the website reports the date correctly. When entering a new row directly
> through ISQL or using IB Expert the timestamp appears correct within the
> database, however my ASP page reports back (for March, 25 2002 @ 10:31):
> December, 24 1994 6:28:16AM
>
> Help?!
>
> --
> >> Richard Abrams
>       Lead Web Developer
>
> >> Artejano Design and Marketing
>       The Old Bakehouse, 21 The Street
>       Lydiard Millicent, Swindon
>       Wiltshire. SN5 3LU
>
> >> Web: www.artejano.com
>       Tel: +44 (0)1793 772243
>       Fax: +44 (0)1793 772207
>       ICQ: 105995147
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers

--
Edgar F. Flores Muñoz