On Aug 29, 2016, at 8:34 AM, Benedict, Tom <[email protected]> wrote:
> 4D does support the datetime data type when the field is created using SQL > commands. It will behave like a date field when referencing it with 4D > commands, but since it actually contains the time part too, you can get a > 'timestamp' by using CAST(myDateTimeField as VARCHAR) in your SQL select > statement. I have seen the TIMESTAMP column type in SQL and I’d like to use it. But how do you put a value into it. The following SQL code does not work: $timeStamp_t:=String(Current date;ISO Date GMT;Current time) INSERT INTO TheTable (TheTimeStamp) VALUES (:$timeStamp_t) What is is the magic to put a 4D time stamp text var into a SQL TIMESTAMP column? Tim ******************************************** Tim Nevels Innovative Solutions 785-749-3444 [email protected] ******************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
