Also, if you want to build a timestamp in 4D here is the format:
http://doc.4d.com/4Dv15R4/4D/15-R4/Principles-for-integrating-4D-and-the-4D-SQL-engine.300-2818873.en.html#1352502
Inserting
=======
Begin SQL
INSERT INTO Table_1 (Field_2)
VALUES ({ ts '1998-05-02 01:23:56.123' });
End SQL
Getting the data back is the same as my last email:
======================================
C_TEXT($text1)
Begin SQL
SELECT CAST(Field_2 AS TEXT)
FROM Table_1
WHERE ID = 3
INTO :$text1;
End SQL
// $text1 = 5/2/98 1:23
C_DATE($dd)
C_TIME($tt)
Begin SQL
SELECT Field_2, Field_2
FROM Table_1
WHERE ID = 3
INTO :$dd, :$tt;
End SQL
// $dd = 05/02/1998
// $tt = 01:23:56
**********************************************************************
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]
**********************************************************************
