>In a table I have a date() not datetime() type
>
>I want to get it into a variable and transform to datetime
>
>Then I need to start at 0 hour to do the operations
>
>example
>
>oginal field: 01/01/2009
>
>I need to transform it in 01/01/2009 00:00
>
>It there an easy way to to it, rather than adding "0000" to the final of the date expression?
m1 = DATE(2009,1,1)
? DTOT(m1)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.