At 10:29 AM 5/12/2003 +0200, you wrote:

>Hi, I have a small problem here, In the system I have to establish a start
>of day (and end of day which is start of tomorrow) based upon both 'NOW' and
>a transaction datetime.
>
>Are there any udf's out there that one could use, alternatively I could cast
>the date as a float, but this I tried and got a conversion error.

What would you achieve by casting the date as a float (if you could, which
you can't...)?

Describe how this start-of-day transition needs to work and we can help.

heLen