Hey Guys, Correct me if I'm wrong, but in the reference material, in multiple locations (for instance page 110) an example is given on how to insert into oracle.
It says:
AcctColumnDefTIME_STAMP,Timestamp,formatted-date,to_date\
('%e %m %Y %H:%M:%S', 'DD MM YYYY HH24:MI:SS')
This will result in a an insert statement something like this:
insert into ACCOUNTING(TIME_STAMP, ......) values
(to_date('16 02 1999 16:40:02', 'DD MM YYYY HH24:MI:SS'), ....)
According to further down in the manual %e is actually the two digits of the
year. %i is the day of the month.
%i The Timestamp day of the month (2 digits)
Thanks
Martin.
Martin Edge
Software Development, Business Analysis, Product Management and Design
[cid:[email protected]]
Emersion Software Systems Pty Ltd
Phone: .......... 1300 793 310
Fax: .............. 1300 793 320
Address: ........ L7, 313 LaTrobe Street, Melbourne VIC 3000
Website: ....................
http://www.emersion.com.au<http://www.emersion.com.au/>
General Enquiries: ...... [email protected]<mailto:[email protected]>
________________________________
This communication may contain CONFIDENTIAL or copyright information of
Emersion Software Systems Pty Ltd (ABN 28 119 061 791). If you are not an
intended recipient, you MUST NOT read, print, keep, forward, copy, use, save,
retransmit or rely on this communication or any attachments, and any such
action is unauthorised and prohibited. If you have received this communication
in error, please reply to this e-mail to notify the sender of its incorrect
delivery, and then delete both it and your reply. Emersion does not guarantee
the integrity of any emails or any attached files. The views or opinions
expressed are the author's own and may not reflect the views or opinions of
Emersion. Thank you.
________________________________
<<inline: image001.jpg>>
_______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator
