[RADIATOR] reference manual - date stamps

Martin Edge medge at emersion.com.au
Thu Jul 22 22:04:06 CDT 2010


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:image001.jpg at 01CB2A67.87FE9E40]

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: ...... info at emersion.com.au<mailto:info at emersion.com.au>

________________________________
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.
________________________________


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20100723/628bc0fc/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 5365 bytes
Desc: image001.jpg
Url : http://www.open.com.au/pipermail/radiator/attachments/20100723/628bc0fc/attachment.jpg 


More information about the radiator mailing list