Re: Problem in inserting date

2002-06-04 Thread R.C.Nougain
IL PROTECTED]> To: "R.C.Nougain" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 7:23 PM Subject: Re: Problem in inserting date > On Tue, 4 Jun 2002, R.C.Nougain wrote: > > > Bad answer. If you 'guess', then don't answer. The idea

Re: Problem in inserting date

2002-06-04 Thread Jan Muszynski
On 4 Jun 2002 at 18:57, R.C.Nougain wrote: > Bad answer. If you 'guess', then don't answer. The idea behind the > date_format is to format a date as per user's need and should not be forced > to a particular format just because some countries follows some format. > Still looking for serious answe

Re: Problem in inserting date

2002-06-04 Thread Thomas Spahni
On Tue, 4 Jun 2002, R.C.Nougain wrote: > Bad answer. If you 'guess', then don't answer. The idea behind the > date_format is to format a date as per user's need and should not be forced > to a particular format just because some countries follows some format. > Still looking for serious answer?

Re: Problem in inserting date

2002-06-04 Thread Egor Egorov
R.C.Nougain, Tuesday, June 04, 2002, 1:56:13 PM, you wrote: RCN> create table dt (dt datetime); RCN> --- OK RCN> insert into dt values ( date_format('04/06/2002 13:48:38', '%d/%m/%Y RCN> %H:%i:%s')); RCN> --- Surprisingly it enters NULL RCN> insert into dt values ( date_format('2002/04/06 13:48

Re: Problem in inserting date

2002-06-04 Thread mysql
some format. > Still looking for serious answer? > > > > > - Original Message - > From: "Harald Fuchs" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 04, 2002 6:26 PM > Subject: Re: Problem in inserting date > &

Re: Problem in inserting date

2002-06-04 Thread R.C.Nougain
- From: "Harald Fuchs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 6:26 PM Subject: Re: Problem in inserting date > In article <000901c20bc2$7b286100$221464a4@cimws34>, > "R.C.Nougain" <[EMAIL PROTECTED]> writes