Karen,
R:BASE eXtreme 9.1 (64), U.S. Version, Build: 9.1.5.20816 (not most recent build) The below quick test returns proper values without error either DATE FORMAT MM/DD/YY, OR MM/DD/YYYY DROP t_test CREATE TEMPORARY TABLE `t_test` + (`TestDate` DATETIME, + `WO` TEXT (10)) SET VAR v1 DATETIME = NULL SET VAR vwo TEXT = NULL SET VAR vwo = 'TESTWO' SET VAR v1 = .#NOW INSERT INTO t_test (testdate,wo) VALUES (.v1,.vwo) CLS BROWSE * FROM t_test RETURN Regards, Brad Davidson From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, October 16, 2012 9:03 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Datetime tutorial 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
