Re: Date and Time

2012-01-08 Thread Govinda
> > leave it stored as a timestamp type or datetime type, and when you need to > display it otherwise.. then covert with date() oops, Paul's post reminded me I was suggesting a PHP function here ^^^ ... and this is the MySQL list. > -G -- MySQL General Mailing List For list archives: http:/

Re: Date and Time

2012-01-08 Thread Paul DuBois
On Jan 8, 2012, at 2:21 PM, Donovan Brooke wrote: > Hello, I'm doing an insert into with date and time type fields. > > I was reading: > http://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html > > My question is: is the format always 'year month day'?.. or can we save dates > in 'mo

Re: Date and Time

2012-01-08 Thread Govinda
> What's your problem/reason with how it is? I assume Andy means: leave it stored as a timestamp type or datetime type, and when you need to display it otherwise.. then covert with date() -G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

Re: Date and Time

2012-01-08 Thread Donovan Brooke
Peter Brawley wrote: On 1/8/2012 2:21 PM, Donovan Brooke wrote: Hello, I'm doing an insert into with date and time type fields. I was reading: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html My question is: is the format always 'year month day'?.. or can we save dates in 'mo

Re: Date and Time

2012-01-08 Thread Peter Brawley
On 1/8/2012 2:21 PM, Donovan Brooke wrote: Hello, I'm doing an insert into with date and time type fields. I was reading: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html My question is: is the format always 'year month day'?.. or can we save dates in 'month day year' as well

Re: Date and Time

2012-01-08 Thread Andrew Moore
What's your problem/reason with how it is? Andy On Sun, Jan 8, 2012 at 8:21 PM, Donovan Brooke wrote: > Hello, I'm doing an insert into with date and time type fields. > > I was reading: > http://dev.mysql.com/doc/**refman/5.1/en/date-and-time-**literals.html

Re: date and time functions.

2004-07-04 Thread Eric Bergen
Date modification functions are listed in the manual here: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html If you are just trying to add a year to a column try something like this. update table set col = col + interval 1 year; -Eric On Sun, 4 Jul 2004 18:22:04 +1000, Hari Yell

Re: date and time

2003-07-08 Thread William R. Mussatto
> Hi, > > can someone explain me the avantage of using date and time, and also can > i set time + XX minutes?? > > Thanx > Anthony Short answer is: You can use the date and time functions and formats. There is one or just use '+' or '-' See chapter 6 in the ref. manual. If you need both date and