Re: [PHP-DB] Retrieving a date from Oracle. Please help!

2002-05-24 Thread max
OTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 8:39 PM Subject: RE: [PHP-DB] Retrieving a date from Oracle. Please help! > > -Original Message- > > From: maxim [mailto:[EMAIL PROTECTED]] > > Sent: 23 May 2002 17:00 > > > > Hi all! > &g

Re: [PHP-DB] Retrieving a date from Oracle. Please help!

2002-05-23 Thread Michael Bretterklieber
Hi, ALTER SESSION SET NLS_DATE_FORMAT="-MM-DD HH24:MI:SS" bye, maxim wrote: > Hi all! > The problem is I can't get expected datetime value from SELECT query on > Oracle table that has a field of type DATE. Seems like datetime looses its > time part. > > The code is like as follows: > ... >

RE: [PHP-DB] Retrieving a date from Oracle. Please help!

2002-05-23 Thread Ford, Mike [LSS]
> -Original Message- > From: maxim [mailto:[EMAIL PROTECTED]] > Sent: 23 May 2002 17:00 > > Hi all! > The problem is I can't get expected datetime value from > SELECT query on > Oracle table that has a field of type DATE. Seems like > datetime looses its > time part. The default format

RE: [PHP-DB] Retrieving a date from Oracle. Please help!

2002-05-23 Thread Ford, Mike [LSS]
> -Original Message- > From: maxim [mailto:[EMAIL PROTECTED]] > Sent: 23 May 2002 17:00 > > Hi all! > The problem is I can't get expected datetime value from > SELECT query on > Oracle table that has a field of type DATE. Seems like > datetime looses its > time part. The default format

Re: [PHP-DB] Retrieving a date.

2002-03-04 Thread Ralph Friedman
In article <[EMAIL PROTECTED]>, Ken Thompson wrote: > Great, that explains better than "most" of the tutorials I've read. > It is unfortunate that most if not all reference documentation expect the > reader to have a college degree just on their subject in order to understand > "wot in 'ell" th

Re: [PHP-DB] Retrieving a date.

2002-03-03 Thread DL Neil
> > Ok? > Great, that explains better than "most" of the tutorials I've read. > It is unfortunate that most if not all reference documentation expect the > reader to have a college degree just on their subject in order to understand > "wot in 'ell" they're saying. > I've done pretty well in figur

Re: [PHP-DB] Retrieving a date.

2002-03-03 Thread Ken Thompson
On Sunday 03 March 2002 02:48 am, DL Neil wrote: > Ken, > > > > Check out DAYOFMONTH() and MONTH() and a wealth of other useful date > > > functions. RTFM: 6.3.4 Date and Time Functions > > > > There's a few interesting items here OK, Thanks for the pointer. > > Go for it... > > > > The answer to

Re: [PHP-DB] Retrieving a date.

2002-03-03 Thread DL Neil
Ken, > > Check out DAYOFMONTH() and MONTH() and a wealth of other useful date > > functions. RTFM: 6.3.4 Date and Time Functions > There's a few interesting items here OK, Thanks for the pointer. Go for it... > > The answer to your question about AUTO_INCREMENT 'reset' can be found at > > 6.5.3

Re: [PHP-DB] Retrieving a date.

2002-03-02 Thread Ken Thompson
On Saturday 02 March 2002 16:13, DL Neil wrote: > Ken, > > Check out DAYOFMONTH() and MONTH() and a wealth of other useful date > functions. RTFM: 6.3.4 Date and Time Functions There's a few interesting items here OK, Thanks for the pointer. > The answer to your question about AUTO_INCREMENT 're

Re: [PHP-DB] Retrieving a date.

2002-03-02 Thread DL Neil
Ken, Check out DAYOFMONTH() and MONTH() and a wealth of other useful date functions. RTFM: 6.3.4 Date and Time Functions The answer to your question about AUTO_INCREMENT 'reset' can be found at 6.5.3 CREATE TABLE Syntax under "table_options". Regards, =dn > I have a test table with the ususal