> Hello, I have a TIMESTAMP field and sometimes I need
> only the date portion, to solve this, in SQL Server I
> use this query:
> SELECT CONVERT(nvarchar(8), FIELD_DATE, 112) AS
> TEXT_DATE
> FROM TABLE_NAME
>
> Is there an equivalent CONVERT() function?
> Is there a way to obtain only the date portion without
> converting it to text?

In a dialect 3 database:

CAST(YOURTIMESTAMP AS DATE) ...





--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com