WHY you don't use DATE data type directly?? in firebird and interbase 6.0, there are 3 datetime data type; DATE (manage date data only); TIME manage time only and TIMESTAMP manage both date and time.
i don't know what is your goals here..
but if you still need this, you can make some trigger to do that...
sory for my bad english
best regards
Wayne Forrest <wayne@...> wrote:
How can I only get DATE portion of a TIMESTAMP;

I have a field that is of type TIMESTAMP I would like to have a computed
field that stores ony the "date" portion and not the TIME portion.


[Non-text portions of this message have been removed]


Yahoo! Groups SponsorADVERTISEMENT


---------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.





---------------------------------
Do you Yahoo!?
Meet the all-new My Yahoo! � Try it today!

[Non-text portions of this message have been removed]