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?

Thanks in advance,
William GS




__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com