Timestamp contains both date and time if you use dialect 3. Tables created with dialect 1 use DATE as a timestamp (new tables should be created with dialect 3).

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of dirinler
Sent: 23. juni 2008 11:02
To: firebird-support@yahoogroups.com
Subject: [firebird-support] datetime

Hi There
FB 2.1
i have a problem with date and time format
i wantto save my records as datetime(10.05.2008 10:41) and how i must
set this fileds type?there are 2 date types date and time but they are
not together(datetime).which field type i must use i can show the
record as datetime?
thanks.


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links