🚀 go-pugleaf

Quinn Wildman (CodeGear Developer Support) wrote:
> However, if you subtract two timestamps you get a number. You can then 
> do math on that. Example:
> 
> select
> 
> select current_timestamp-cast('1/1/0001' as timestamp) from rdb$database;

Hi Quinn,

Thank you!  I took a little while to really see where you were going 
with this, but it did give me a solution!

For future reference, to get a distinct identifier for a day I 
subtracted the date field from "NOW" (you could use any datetime) then 
cast the resulting floating point number as an integer.  The result may 
not be the date itself, but it is a unique identifier for each day which 
is enough for me.

Eg:

SELECT
CAST(MyDateField - "NOW" AS Int)

FROM
MyTable


Thank you, thank you, thank you!

-- 
Robin.

Australian Bridal Accessories := http://www.bridalbuzz.com.au
Turbo for Noobs (a work in progress) := http://turbofornoobs.blogspot.com/