In my copy of 9.1 (maybe not the same build) I do get the .#NOW to give me a datetime. But my try at an insert into a DateTime column still gives me the datatype error.
Karen In a message dated 10/16/2012 10:55:54 AM Central Daylight Time, [email protected] writes: > Karen, > > This was tested in 9.1 > SET VAR vNow DATETIME = .#NOW > > I created a table mytable with one DATETIME column mynow > > Then I issued the command > INSERT INTO mytable VALUES (.vNow) > > No errors were generated in any of these steps. > > Jan >
