>
> 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:/
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&#x
> 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:/
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 w
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
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<http:/
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?
Thanks,
Donova
>-Original Message-
>From: Jason Todd Slack-Moehrle [mailto:mailingli...@mailnewsrss.com]
>Sent: Friday, June 26, 2009 1:10 PM
>To: mysql@lists.mysql.com
>Subject: Default Date and Time
>
>Hi All,
>
>I want to create a table that defaults to current_date and c
Hi Jason
The DEFAULT value can't be an expression.
2009/6/26 Jason Todd Slack-Moehrle
> Hi All,
>
> I want to create a table that defaults to current_date and current_time.
>
> I have:
>
> CREATE TABLE `personalevent`(
>`pevent` mediumint(10) NOT NULL,
>`eventid` mediumint(10)
Hi All,
I want to create a table that defaults to current_date and current_time.
I have:
CREATE TABLE `personalevent`(
`pevent` mediumint(10) NOT NULL,
`eventid` mediumint(10) NOT NULL,
`userid` mediumint(10) NOT NULL,
`username` varchar(10) NOT NULL,
`pa
I'm not sure what you mean by date *conversions* but the date *functions*
can be found here:
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html. You will
probably use these for most conversions you attempt.
Rhino
- Original Message -
From: "Robert A. Rawlinso
I have read somewhere how to do the conversions but for some reason I
can not find it again. Now I need to do conversions soon. Could someone
direct me to where the documentation is located?
Thanks for any help you can offer.
Bob Rawlinson
--
Robert A. Rawlinson
Felicity Ohio 45120
--
MySQL Gen
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
Hi All,
I trying to add one year to date function is there a good documentation on
how we can manipulate on date function.
Changing the format of dates for mysql.
Thank you ,
Harry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Subject: Migrating Access Tables -- Empty Columns, Date and Time
I'm migrating a Microsoft Access 2002 (Service Pack 3) table constructed
by my wife to a corresponding table in MySQL 4.0.20. Some columns in
most of the 3000+ rows are empty. Some of these are contiguous empty
columns. I don'
ne 28, 2004 8:21 PM
To: [EMAIL PROTECTED]
Subject: Migrating Access Tables -- Empty Columns, Date and Time
I'm migrating a Microsoft Access 2002 (Service Pack 3) table constructed
by my wife to a corresponding table in MySQL 4.0.20. Some columns in
most of the 3000+ rows are empty. Some of
etimes
several) are seen, what does mysqlimport/LOAD DATA do to the
corresponding column entrie(s)? Will it set them to NULL? Or to the
default specified in the CREATE TABLE statement? Should I explicitly
set
these to NULL where permitted by the column type?
Last of all, look at this date and time s
o to the
corresponding column entrie(s)? Will it set them to NULL? Or to the
default specified in the CREATE TABLE statement? Should I explicitly set
these to NULL where permitted by the column type?
Last of all, look at this date and time stamp exported by Access:
,2/12/1998 0:00:00,
Will mysql
l: NEFACOMP" <[EMAIL PROTECTED]>
To: "Emilio Ruben Estevez" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, October 02, 2003 22:16
Subject: Re: How can i make mysql to print date and time automatically?
> INSERT INTO your_table (field1, field2, field3) VAL
ober 01, 2003 17:09
Subject: How can i make mysql to print date and time automatically?
> Hi, im develping an application, and was wondering how can i make mysql
get
> time and date from pc and print it automatically in the time field and
date
> field so the user dont have to worry about
On Wed, 2003-10-01 at 10:09, Emilio Ruben Estevez wrote:
> Hi, im develping an application, and was wondering how can i make mysql get
> time and date from pc and print it automatically in the time field and date
> field so the user dont have to worry about entering the coorect time and
> date.
Hi, im develping an application, and was wondering how can i make mysql get
time and date from pc and print it automatically in the time field and date
field so the user dont have to worry about entering the coorect time and
date. Is this posible, ive created a databse with fields hour(time) and
> 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 th
Hi,
can someone explain me the avantage of using date and time, and also can i set time +
XX minutes??
Thanx
Anthony
24 matches
Mail list logo
