That was a stupid question sorry! I can do it just using a string comparison.


Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd

----- Original Message -----
From: Robert martin
To: firebird-support@yahoogroups.com
Sent: Thursday, October 21, 2004 12:18 PM
Subject: [firebird-support] Date time select


Hi

I apologise if this is a stupid question but.....

We have a table with APLastDate (Date type) and APLastTime (Char(10) in
hh:nn:ss format) fields. I want to do an SQL which is, here Date and Time
are greater than these values. Is this possible? Can I cast a String in
that format to a Time and use it in a comparison?


Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd



Yahoo! Groups Sponsor
ADVERTISEMENT





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

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

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

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



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