Oracle Database :: timestamp format


	timestamp format I have a timestamp field in my DB, what is the correct format to insert the right parameters??? Mariano schrieb am 11.04.2007 in <1176324768.421002.203@o5g2000hsb.googlegroups.com>: > I have a timestamp field in my DB, what is the correct format to > insert the right parameters??? It depends on the session parameters, the database parameters ... I prefer to do it like insert into MyTable (MyTimeStamp) values (ToDate('DD.MM.YYYY','11.04.2007')); But if you need to insert the actual time so you should use sysdate. insert into MyTable (MyTimeStamp) values (sysdate); Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de -----------------------------------------------Reply----------------------------------------------- I have a timestamp field in my DB, what is the correct format to insert the right parameters??? -----------------------------------------------Reply----------------------------------------------- On Wed, 11 Apr 2007 23:09:07 +0200, Andreas Mosmann - Hide quoted text - <mosm@expires-30-04-2007.news-group.org> wrote: >Mariano schrieb am 11.04.2007 in ><1176324768.421002.203@o5g2000hsb.googlegroups.com>: >> I have a timestamp field in my DB, what is the correct format to >> insert the right parameters??? >It depends on the session parameters, the database parameters ... >I prefer to do it like >insert into MyTable (MyTimeStamp) values >(ToDate('DD.MM.YYYY','11.04.2007')); >But if you need to insert the actual time so you should use sysdate. >insert into MyTable (MyTimeStamp) values (sysdate); >Andreas Mosmann Sorry to say so but timestamps are NOT dates! If the OP has a true timestamp column (of datatype timestamp) he needs the SYSTIMESTAMP function. dates never contain any timezone info!!! -- Sybrand Bakker Senior Oracle DBA -----------------------------------------------Reply----------------------------------------------- On Apr 11, 11:17 pm, sybra@hccnet.nl wrote: - Hide quoted text - > On Wed, 11 Apr 2007 23:09:07 +0200, Andreas Mosmann > <mosm@expires-30-04-2007.news-group.org> wrote: > >Mariano schrieb am 11.04.2007 in > ><1176324768.421002.203@o5g2000hsb.googlegroups.com>: > >> I have a timestamp field in my DB, what is the correct format to > >> insert the right parameters??? > >It depends on the session parameters, the database parameters ... > >I prefer to do it like > >insert into MyTable (MyTimeStamp) values > >(ToDate('DD.MM.YYYY','11.04.2007')); > >But if you need to insert the actual time so you should use sysdate. > >insert into MyTable (MyTimeStamp) values (sysdate); > >Andreas Mosmann > Sorry to say so but timestamps are NOT dates! > If the OP has a true timestamp column (of datatype timestamp) he needs > the SYSTIMESTAMP function. > dates never contain any timezone info!!! > -- > Sybrand Bakker > Senior Oracle DBA Also, SELECT SYSTIMESTAMP , TIMESTAMP '1000-01-01 01:23:45' , TO_TIMESTAMP('1000-01-01 01:23:45.678','YYYY-MM-DD HH24:MI:SS.FF3') FROM dual;

MS Dynamics CRM 3.0

Oracle Database

timestamp format