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 >[EMAIL PROTECTED] >http://list.cobalt.com/mailman/listinfo/cobalt-developers -- Edgar F. Flores Mu�oz _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
