On Thursday 01 December 2005 11:24 pm, Ron Savage wrote:
Hi Folks
I see that if I have
create table history (history_timestamp timestamp not null)
I can insert into this with
insert into history (history_timestamp) values
(to_date('2005-12-02', '-MM-DD') || ' 03:39:25PM')
opps 24
On Thursday 01 December 2005 11:24 pm, Ron Savage wrote:
Hi Folks
I see that if I have
create table history (history_timestamp timestamp not null)
I can insert into this with
insert into history (history_timestamp) values
(to_date('2005-12-02', '-MM-DD') || ' 03:39:25PM')
On Friday 02 December 2005 12:58 am, you wrote:
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)
It's not that sqlplus is truncating your output. The default format is
configured at database startup, which is overridable in various ways (
environmental variable NLS_DATE_FORMAT, alter session set NLS_DATE_FORMAT = ).
This format pertains to both selects and inserts.
He's using a
On Fri, 02 Dec 2005 14:18:49 -0800, Mark wrote:
Hi Folks
Thanx for all the suggestions. I have been reading Oracle's docs, but sometimes
it's a matter of not knowing what to look for, and sometimes it's a matter of
having been mislead by the manuals I have, which are printed by Thomson (Course
Hi Folks
I see that if I have
create table history (history_timestamp timestamp not null)
I can insert into this with
insert into history (history_timestamp) values
(to_date('2005-12-02', '-MM-DD') || ' 03:39:25PM')
(there's a space before the 03)
But what if my original date-time is a
: Friday, 2 December 2005 4:25 PM
To: List - DBI users
Subject: Inserting into Oracle's timestamp type
Hi Folks
I see that if I have
create table history (history_timestamp timestamp not null)
I can insert into this with
insert into history (history_timestamp) values
(to_date('2005-12-02
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, '-MM-DD HH24:MI:SS'))