timestamp - behaviour does not match documentation
Posted: Tue 30 Aug 2016 12:58
Hi,
According to documentation of unidac, timestamp can be specified as this:
{timestamp '2006-12-31 23:59:59'}
However, if I run in a TUniQuery:
INSERT INTO JOBLIST(ID, DTIN, DTOUT, CUSTOMER, QTY, SUBJECT, REF, SENDNOTE, DTTRT,PROCBY, DONE, CLIENT, REROUBY, DTASKED, DTPROMISED, ARCHIVE, DTREC, NICKNAME, REFCDE, FACTSTATE, NUMORDER, OWNER, SENDBACKFILE, RETURNFILENAME,
RETURNFILENAME2, CARDQTY, FeedbackConfirmationFile, BAT, INTERNALJOB, ORDERTYPE, EXTERNALORDERID, ACCOUNTINGINVOICE) VALUES (127950, {timestamp '2016-08-30 14:44:59'}, {timestamp '1900-01-01 00:00:00'},
4443, 0, '46501plp.Xml', '2016083014445801', '', {timestamp '2016-08-30 14:44:59'}, 25,'N', 'Isabel Nv/sa', 0, {timestamp '1900-01-01 00:00:00'}, {timestamp '1900-01-01 00:00:00'}, '46501PLP.XML.ZIP',
{timestamp '1900-01-01 00:00:00'}, 'ISAP', '', 0, 0, 1, 'N', '', '', 0, '', 'N', 'N', '', NULL, '')
I get an error: hour must be between 1 and 12.
I can see in dbmonitor that hh24 is not used to format the hour.
How can I specify 15.30 (for 3.30 pm)?
I saw in a very old thread that there was a Option TimedFormat that doesn't exist anymore for oracle.
Kind regards,
According to documentation of unidac, timestamp can be specified as this:
{timestamp '2006-12-31 23:59:59'}
However, if I run in a TUniQuery:
INSERT INTO JOBLIST(ID, DTIN, DTOUT, CUSTOMER, QTY, SUBJECT, REF, SENDNOTE, DTTRT,PROCBY, DONE, CLIENT, REROUBY, DTASKED, DTPROMISED, ARCHIVE, DTREC, NICKNAME, REFCDE, FACTSTATE, NUMORDER, OWNER, SENDBACKFILE, RETURNFILENAME,
RETURNFILENAME2, CARDQTY, FeedbackConfirmationFile, BAT, INTERNALJOB, ORDERTYPE, EXTERNALORDERID, ACCOUNTINGINVOICE) VALUES (127950, {timestamp '2016-08-30 14:44:59'}, {timestamp '1900-01-01 00:00:00'},
4443, 0, '46501plp.Xml', '2016083014445801', '', {timestamp '2016-08-30 14:44:59'}, 25,'N', 'Isabel Nv/sa', 0, {timestamp '1900-01-01 00:00:00'}, {timestamp '1900-01-01 00:00:00'}, '46501PLP.XML.ZIP',
{timestamp '1900-01-01 00:00:00'}, 'ISAP', '', 0, 0, 1, 'N', '', '', 0, '', 'N', 'N', '', NULL, '')
I get an error: hour must be between 1 and 12.
I can see in dbmonitor that hh24 is not used to format the hour.
How can I specify 15.30 (for 3.30 pm)?
I saw in a very old thread that there was a Option TimedFormat that doesn't exist anymore for oracle.
Kind regards,