Hi Tim, > What is is the magic to put a 4D time stamp text var into a SQL TIMESTAMP > column?
Here are some examples: Inserting: ======= Begin SQL INSERT INTO Table_1 (Field_2) VALUES (CURRENT_TIMESTAMP()); End SQL Getting the data back: ================= Using Cast: C_TEXT($text1) Begin SQL SELECT CAST(Field_2 AS TEXT) FROM Table_1 WHERE ID = 1 INTO :$text1; End SQL // theText = 8/29/2016 10:55 Using date and time vars: C_DATE($dd) C_TIME($tt) Begin SQL SELECT Field_2, Field_2 FROM Table_1 WHERE ID = 1 INTO :$dd, :$tt; End SQL // $dd = 8/29/2016 // $tt = 10:55:31 Kind Regards, Tim PENNER ********************************************************************** 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] **********************************************************************
