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,
timestamp - behaviour does not match documentation
Re: timestamp - behaviour does not match documentation
Please check the needed behavior using the current UniDAC version 6.4.14 (08-Sep-16)