date format in the select statement

[Elroacho]

Hi,

I'm trying to write a simple select statement that includes a date, however I want to drop the time do all I get in the record set is dd/mm/yyy.

Any ideas?

Cheers in advance

 

[MartijnTonies]

What version of InterBase?

If IB6 and up, try CAST(mytimestampfield AS DATE) in a Dialect 3 database.



--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server
Upscene Productions

http://www.upscene.com

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, Oracle, MySQL & MS SQL Server

http://www.upscene.com

 

[Elroacho]

Hi,

I am working with IB7. I have used the cast function but set it as string(11) which chops of the time. This is very crude I know but that's what the documentation told me to do! However 'said' documentation is for v5 so I will try your suggestion when I get the chance.

Cheers,
Kevin.