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

["Richard Abrams" <richard@xxxxxxxxxxxxxx>]

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