Hi Clay,

> How can I retrieve just the date portion of a timestamp field in SQL? IOW,
> what do I need to do to get a value like "11/11/2001" instead of "11/11/2001
> 11:11:11 AM"?

In a dialect 3 database:


select cast(date_time as date) from your_table;


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