On Fri, 2 Dec 2005 17:50:08 +1100, Steve Baldwin wrote: Hi Steve
Thanx. > This may not answer your question, but you can incorporate the time > format mask in the call to TO_DATE. For example ... > > insert > into history (history_timestamp) > values (to_date(:ts_val, 'YYYY-MM-DD HH24:MI:SS')) Yes, I tried that first actually, but when I displayed the result via a select in sqlplus all I saw was the date part. However it now occurs to me that that display may have been truncated by sqlplus since I did not use column history_timestamp format a30 or some such :-(. And it's 6:00 pm Friday here now, and I don't feel like going back to work to test it, for some reason... -- Cheers Ron Savage, [EMAIL PROTECTED] on 2/12/2005 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company
