Date/Time

[SerialNinja]

I'm using impromptu 7.3, Informix 3.32 DB, I have a date/time field I need to group by and trunc the time
from '2001-12-15 23:50:26'
to a simple date'2001-12-15'
Trying to do it in sql but Im not that familuar with this DB.
Any ideas?
Im drawing a blank for some reason.

 

[Kozusnik]

You could create a calculated field.

I think I used a function "datetime to date", or something like create date(substr(field,1,10))

Mark

SELECT * FROM management WHERE clue > 1
> 0 rows returned

--ThinkGeek T-Shrit