I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
In the last episode (Sep 14), John Meyer said:
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
Nope. Assuming your input string
Dan Nelson wrote:
In the last episode (Sep 14), John Meyer said:
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
Nope.
Hi All
Is it possible in mysql to create a date field that stores year and month
only (-MM) without having to zero out the day or use varchar type fields
Thanks
Olaf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is it possible in mysql to create a date field that stores year and month
only (-MM) without having to zero out the day or use varchar type fields
Best here is to just use a DATE field, then use DATE_FORMAT when you
want to pull up the customized date. It will get stored as a timestamp
Thanks...
My issue is not storage, it is confidentiality.
I am not allowed to store the day of birth as it is considered identifying
information (in medical records).
I do not even have the day, I want to pass a date in format (-MM) to a
date field if possible.
On 1/15/07 11:37 AM, Chris
Olaf Stein wrote:
Thanks...
My issue is not storage, it is confidentiality.
I am not allowed to store the day of birth as it is considered identifying
information (in medical records).
I do not even have the day, I want to pass a date in format (-MM) to a
date field if possible.
Pass the
Assign all dates to have a day of 01
Store in a date field, use DATE_FORMAT to just extract the MM and .
As you don't have the real day information it doesn't matter what day is used,
so long as it present in all months.
Hope this helps
Robert Gehrig
Webmaster at www.gdbarri.com
e-mail:
Hi Friends,
I want to set the default date format as dd-mon-. How do i do this in
mysql.
I tried this, set global date_format='%d-%m-%y';. The command executed and
when i did show variable it show the new format.
But when i tried the below test, i got wrong results. Can u please help.
mysql
Ananda Kumar wrote:
Hi Friends,
I want to set the default date format as dd-mon-. How do i do this in
mysql.
The short answer: not.
http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html
lists the variables you can change by the SET GLOBAL or SET SESSION
command
I have some data where the date is already in USA format (MM-DD-).
I would like to be able to insert this data without having to massage
the date in the code.
Is there a way to specify the Date Format for an INSERT statement?
Something like:
INSERT INTO tblMyTable(myDate) VALUES
before :)
Is there a way to specify the Date Format for an INSERT statement?
Something like:
INSERT INTO tblMyTable(myDate) VALUES(DATE_FORMAT('USA', '12-31-2004');
Try the STR_TO_DATE function:
SELECT STR_TO_DATE('12-31-2004','%m-%d-%Y');
2004-12-31
--
Dan Nelson
Dan Nelson wrote:
Is there a way to specify the Date Format for an INSERT statement?
Something like:
INSERT INTO tblMyTable(myDate) VALUES(DATE_FORMAT('USA', '12-31-2004');
Try the STR_TO_DATE function:
SELECT STR_TO_DATE('12-31-2004','%m-%d-%Y');
2004-12-31
Yup.. that works
Hello.
This is a frequently asked question. For example read these threads:
http://lists.mysql.com/mysql/175324
http://lists.mysql.com/mysql/177730
Shuan [EMAIL PROTECTED] wrote:
Dear all,
How to change the Default Date/DateTime Format of MySQL server?
I'm using
:[EMAIL PROTECTED]
Sent: Thursday, March 24, 2005 10:57 AM
To: Mark Mchugh
Cc: mysql list
Subject: Re: changing default date format on server
Mark Mchugh [EMAIL PROTECTED] wrote on 03/24/2005 10:26:44 AM:
hi,
How can i change the default date field to european format, i.e.
dd/mm/
--date_format=name The DATE format (For future).
date_format (No default value)
[/shell]
This has been said before, but date_format is not implemented on the
server. You can set it, but I don't think it does anything.
J.R.
PS - Sorry it took me so long Mark, was busy
Dear all,
How to change the Default Date/DateTime Format of MySQL server?
I'm using MySQL 4.1.10-nt on WinXP Pro.
Thanks.
Shuan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello!
Is there a way how to change the date and time format accepted and
returned by MySQL from '-mm-dd' to something different? I've seen
several posts here telling it's impossible but they are quite old. Is
it still true in recent MySQL versions? I can see date_format,
datetime_format and
and time_format in SHOW VARIABLES, it's even
documented somewhere (e.g. http://mysqld.active-venture.com/SET_OPTION.html )
but it seems it doesn't do anything in MySQL 4.1.7.
`mysqld.exe --help --verbose | grep _format` says:
--date_format=name The DATE format (For future).
So I guess
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format mm/dd/.
Can someone please help. I am also having trouble converting -mm-dd into a normal
mm/dd/ format as well.
I am using the following line of code:
date('m/d/Y', $row10['modified']);
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 05 July 2004 06:07 pm, Gary Mack wrote:
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format
mm/dd/. Can someone please help. I am also having trouble converting
-mm-dd into a normal mm/dd/
Gary Mack wrote:
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format mm/dd/. Can someone please help. I am also having trouble converting -mm-dd into a normal mm/dd/ format as well.
Normal format *is* -mm-dd.
I am using the following line of code:
Gary:
Am I looking at PHP's date() function? You are taking a timestamp
from a MySQL table and wanting to convert it into a US format. Is the
timestamp stored in your MySQL table a Unix timestamp or a MySQL
timestamp?
It's important to note that you can't take a MySQL timestamp and use
PHP's
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format
mm/dd/. Can someone please help. I am also having trouble
converting -mm-dd into a normal mm/dd/ format as well.
A bit off-topic but,
if you are able to use Perl anytime during your
Matt Tucker [EMAIL PROTECTED] wrote:
I'm moving a JavaServlet app over from Tomcat on Win2K with a MS SQL 7 DB to Tomcat
on Red
Hat Linux with mySQL. Of course, there's about a hundred queries that use dates and
of
course, they're all in the format mm-dd-. is there a way to format the
Hi,
I'm moving a JavaServlet app over from Tomcat on Win2K with a MS SQL 7 DB to Tomcat on
Red Hat Linux with mySQL. Of course, there's about a hundred queries that use dates
and of course, they're all in the format mm-dd-. is there a way to format the date
column in my mysql tables to
David Carlos Brunstein [EMAIL PROTECTED] wrote:
Hi Egor.
Thanks for your answer. I'm relatively new to MySQL.
Isn't any way -like an environment variable or configuration file
setting or something like that- to change the date format at the MySQL
side, not at client side ?
No. You can
David Carlos Brunstein [EMAIL PROTECTED] wrote:
By these days I'm facing a system DB migration to MySQL (the last
production version) and I have the followin problem. All the SELECTs
sentences are all over the application, and for date/datetime filters
are using the dd/mm/ format in the
Hi Egor.
Thanks for your answer. I'm relatively new to MySQL.
Isn't any way -like an environment variable or configuration file
setting or something like that- to change the date format at the MySQL
side, not at client side ?
Regards,
David.
==
David Carlos Brunstein
Hi,
I'm new to the list.
By these days I'm facing a system DB migration to MySQL (the last
production version) and I have the followin problem. All the SELECTs
sentences are all over the application, and for date/datetime filters
are using the dd/mm/ format in the WHERE clause. Is the same
How can I use the output string of the yearweek() function
(for example, 200346 below):
mysql select dayname(2003-11-12), yearweek(2003-11-12);
+---++
| dayname(2003-11-12) | yearweek(2003-11-12) |
12:56 PM
Subject: yearweek() result back to date format?
How can I use the output string of the yearweek() function
(for example, 200346 below):
mysql select dayname(2003-11-12), yearweek(2003-11-12);
+---++
| dayname(2003-11-12) | yearweek
Hello
Is there anyway to change the default date format
(possibly in a .ini or .cfg file) from -MM-DD to
another format ? (ie, mm/dd/ or any user-defined
format).
The useage that I'm looking at is to import a CSV file
into a table (using Load data infile command)
where dates
Karam Chand [EMAIL PROTECTED] wrote:
Is there anyway to change the default date format
(possibly in a .ini or .cfg file) from -MM-DD to
another format ? (ie, mm/dd/ or any user-defined
format).
No, You can't.
The useage that I'm looking at is to import a CSV file
into a table
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 16, 2003 11:48 AM
Subject: Re: Can I change the date format...
Karam Chand [EMAIL PROTECTED] wrote:
Is there anyway to change the default date format
(possibly in a .ini
probably one of the many replys you'll get on this, but
ORDER BY month(start_date)
assuming the column that has the date is start_date
On Thursday 10 July 2003 14:51, Mike At Spy wrote:
I am trying to create an order by in a select statement that takes a
standard 'date' column in a table and
I am trying to create an order by in a select statement that takes a
standard 'date' column in a table and sorts the returned data by the month
of that date.
Off hand, I tried
ORDER BY start_date(m)
And I know that is wrong. Anyone have any suggestions?
Thanks,
-Mike
--
MySQL General
Try:
order by left(start_date,7)
That will order by year then month for a standard date column..
Cheers,
Andrew
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Thursday 10 July 2003 20:51
To: [EMAIL PROTECTED]
Subject: ORDER BY with Date Format
I am trying
today´s date: 2003-07-01
Hi there,,,
I wrote down this statement
select (current_date - 1 )
and the result was:
(Currentdate -1)
---
20030700
when i write select (current_date )
I have:
(Currentdate)
---
2003-07-01
but
: date format
today´s date: 2003-07-01
Hi there,,,
I wrote down this statement
select (current_date - 1 )
and the result was:
(Currentdate -1)
---
20030700
when i write select (current_date )
I have:
(Currentdate)
---
2003-07
On 1 Jul 2003 at 11:31, Fabio Bernardo wrote:
select (current_date - 1 )
and the result was:
(Currentdate -1)
---
20030700
Use this instead:
SELECT CURRENT_DATE() - INTERVAL 1 DAY;
The documentation for DATE_ADD() and other date and time
* Roger Baklund
[...]
UPDATE a SET new_date =
(
MID(my_date,7,4),'-',
MID(my_date,1,2),'-',
MID(my_date,4,2));
huh? How did this happen...? I just checked my outbox, and the message I wrote
yesterday[1] contained new_date = CONCAT(. It seems as the substring CON has been
replaced
* Wong Zach-CHZ013
[...]
In table a, the columns are
my_date - longtext
num - int(11)
[...]
Q:
How do I convert 08/06/2002 to 2002-08-06 format
LONGTEXT is not a good column type for dates, you should use the special
'date' type, see URL: http://www.mysql.com/doc/en/Column_types.html .
To
this command should get your data moved to a new sql table
insert into table2
select
(concat(mid(my_date,7,4),'-',mid(my_date,1,2),'-',mid(my_date,4,2)))
from table1;
- hcir
On Tuesday, January 28, 2003, at 01:45 PM, Wong Zach-CHZ013 wrote:
Hi
I have a few tables in a database Z, namely
table
Hi
I have a few tables in a database Z, namely
table
a
b
c
In table a, the columns are
my_date - longtext
num - int(11)
eg:
mysql select * from a;
+--+--+--+
| my_date | x|
+--+--+
| 08/06/2002 |1 |
| 08/07/2002 |2 |
hello all,
i have the following selection in my query...
DATE_FORMAT(Images.TIMESTAMP, '%a %b %d at %l:%i %p') as TIME
now, i want to apply LCASE or LOWER to it, but i'm a little unsure how to handle the
syntax with two sets of parentheses.
any insight?
tia,
j
At 12:39 -0400 9/20/02, Stanley, Jason wrote:
hello all,
i have the following selection in my query...
DATE_FORMAT(Images.TIMESTAMP, '%a %b %d at %l:%i %p') as TIME
now, i want to apply LCASE or LOWER to it, but i'm a little unsure
how to handle the syntax with two sets of parentheses.
The
Hello,
I am developing an aplication where I need format the date for inserting
into mySQL.
With DATE_FORMAT I can format the mySQL date to my date, but I haven't
found a good way to format my date to the mySQL date.
My format is 'dd-mm-' and to convert it to '-mm-dd' I'm using
the
Hello Javier,
I am developing an aplication where I need format the date for inserting
into mySQL.
=what language is your application written in?
=dn
With DATE_FORMAT I can format the mySQL date to my date, but I haven't
found a good way to format my date to the mySQL date.
My format is
Hello,
I am developing an aplication where I need format the date for
inserting into mySQL.
=what language is your application written in?
=dn
The application is written in Java, but the problem is that the module
where the dates for the DB are managed is an open source framework and
Hi,
the date format of MySql is /mm/dd (2002/07/16) right?
How I do to insert the date typing in my form dd/mm/ (16/07/2002)?
It is possible?
Thanks,
Elby
_
MSN Photos é a maneira mais fácil e prática de editar e
Em Ter 16 Jul 2002 18:19, Elby Vaz escreveu:
Hi,
the date format of MySql is /mm/dd (2002/07/16) right?
Wrong. The date format of MySQL is -mm-dd.
How I do to insert the date typing in my form dd/mm/ (16/07/2002)?
It is possible?
You have to format your date to insert
Does anyone know if version 4.0 will support formatted date queries.
Example:
select create_date from what_ever where create_date
date_format('03/01/2002','%m/%d/%Y')
sql, query
--
Walter Anthony
System Administrator
National Electronic Attachment
Atlanta, Georgia
1-800-782-5150 ext. 1608
At 11:08 -0400 6/25/02, walt wrote:
Does anyone know if version 4.0 will support formatted date queries.
Example:
select create_date from what_ever where create_date
date_format('03/01/2002','%m/%d/%Y')
Why not just write the date correctly? That is, what does
this gain you?
sql, query
--
Chuck,
Friday, June 14, 2002, 3:01:58 AM, you wrote:
CPP If you have mutli-date fields, can you set one date format in mysql sql
CPP statement for all fields? I have 9 date fields, that like to have the same
CPP format.
What do you mean one date format? MySQL stores data in certain format,
f.e
If you have mutli-date fields, can you set one date format in mysql sql
statement for all fields? I have 9 date fields, that like to have the same
format. Also I don't want it to work fields that have -00-, can I
tell not to show those
Trevor,
Wednesday, May 29, 2002, 3:29:43 AM, you wrote:
TF Running MYSQL 3.23 can the date mmdd be reversed when using Access or VB
TF frontend so that users can enter it as they are used to eg. ddmm.
MySQL stores data in mmdd format, but you can use DATE_FORMAT()
function to
Running MYSQL 3.23 can the date mmdd be reversed when using Access or VB
frontend so that users can enter it as they are used to eg. ddmm. Also I
tried creating a new field for date using DATE(8) BUT the sql statement came
back with an error. I tried changing the format of the date field
: Tuesday, March 05, 2002 7:46 AM
Subject: date format
Hi, please help me with this one!
I now the date_format function, it converts the standard format sql
(-mm-dd)
to any format, but my problem is that i want to convert from another
format
(eg. dd/mm/) to the standard format
razvan,
Tuesday, March 05, 2002, 7:46:31 AM, you wrote:
r Hi, please help me with this one!
r I now the date_format function, it converts the standard format sql
r (-mm-dd)
r to any format, but my problem is that i want to convert from another format
r (eg. dd/mm/) to the
Hi, please help me with this one!
I now the date_format function, it converts the standard format sql
(-mm-dd)
to any format, but my problem is that i want to convert from another format
(eg. dd/mm/) to the standard format, in this way i can use insert with
my format.
Can I
Hi,
I am a new user to MySql, and have recently installed version 3.23.25-beta.
I have a date string of the type 'DD-MON-YY' (for Oracle Users) (Eg.
20-DEC-01')
If I try to insert this into a date field in the table, either as it is, or
via the DATE_FORMAT function, it inserts a NULL
Even when I
, then I shall just proceed to check whether I can do
the required formatting in the frontend before passing it to MySql.
Vaishali
-Original Message-
From: Almar van Pel [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 4:46 PM
To: Vaishali Vaidya
Subject: RE: Date Format
Hi All,
Is there any way to modify the date format used by MyODBC when
returning dates? By example, I have a field in the database with the
value 2001-11-01 (this is Nov. 1st, 2001).
When I read it in my VB program I get the next date 11/1/2001; this
is because the computer date format
On Thursday 26 July 2001 11:03, Claudemir F. Martins wrote:
Hello Friends
Is possible to change the MysQL Date fromat from -mm-dd to dd-mm-
I suppose, by changing the source code, and reompiling, which would break
several other things.
Before posting, please check:
Date |Thu, 26 Jul 2001 15:03:59 -0400
From |Claudemir F. Martins [EMAIL PROTECTED]
Hello!
CFM Hello Friends
CFM Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ?
CFM Thanks
CFM Claudemir F. Martins
You can use DATE_FORMAT function for change output date format
On 26-Jul-2001 Claudemir F. Martins wrote:
Hello Friends
Is possible to change the MysQL Date fromat from -mm-dd to dd-mm-
?
Check for DATE_FORMAT() in the manual.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the
Hello Friends
Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ?
Thanks
Claudemir F. Martins
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Claudemir F. Martins schrieb am Donnerstag, 26. Juli 2001, 21:03:59:
Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ?
No. This is the standard format. You can, however, reformat the
result sets according to your needs. This format allows easy
manipulation of
-388
- Original Message -
From: Werner Stuerenburg [EMAIL PROTECTED]
To: Claudemir F. Martins [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 9:49 AM
Subject: Re: Date Format in MySQL
Claudemir F. Martins schrieb am Donnerstag, 26. Juli 2001, 21:03:59:
Is possible
Is there a default format for Date ?
/mm/dd or
mm/dd/ or
dd/mm/ ?
I am not sure which format I should use in SQL.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
) 767-0249
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
]On Behalf
Of pak
Sent: 18 July 2001 08:58
To: [EMAIL PROTECTED]
Subject: Default date format
Is there a default format for Date ?
/mm/dd or
mm/dd/ or
dd/mm/ ?
I am not sure which
On Thu, 28 Jun 2001 15:30:14 -0300, Alejandro Ralla [EMAIL PROTECTED]
wrote:
You would need to reformat the input date first, within your middleware, like
Perl or PHP. Then you would be able to enter it into your db.
Hi guys, does anyone help me with this simple thing ??
I have a date format
What programming language are you using?
Hi guys, does anyone help me with this simple thing ??
I have a date format problem, I need a spanish format please read the
following lines:
Receive from input 28/06/2001
Want to change it to 2001-06-28 to write the Database
Use to do it DATE_FORMAT
Hope this helps ;)
What programming language are you using?
Hi guys, does anyone help me with this simple thing ??
I have a date format problem, I need a spanish format please read the
following lines:
Receive from input 28/06/2001
Want to change it to 2001-06-28 to write the Database
Use
Database,sql,query
-Message d'origine-
De : Nicolas Villatte [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 22 mai 2001 23:18
À : '[EMAIL PROTECTED]'
Objet : Date format prolem
I insert a date like this '2002-10-15' in the DB, everything
is ok when doing a select with DBTools
Is there a simple way to force mySQL to always return dates and
datetime in
ISO
long format, without the '-', ':' and spaces? (in a TIMESTAMP(14) like
format)
I always want 20010517 rather than 2001-05-17,
and 20010517130500 rather than 2001-05-17 13:05:00
Use ints and bigints?
On 09-May-01 Darla Baker wrote:
I have a text file which is extracted from a non-sql
database each night and then a cron sql script runs to
insert the text data into the mysql database tables.
My problem is that the date data in the text file is
formatted incosistently (12/31/00 or
I have a text file which is extracted from a non-sql
database each night and then a cron sql script runs to
insert the text data into the mysql database tables.
My problem is that the date data in the text file is
formatted incosistently (12/31/00 or 12-31-00) and so
the fields that hold date
Hi,
I want to import in my DB in MySql a data. Everyting data is ok
but for date format ( yy/mm/dd ) this I have in .csv format when I
importI see that -00-00 in all date fields
Any help is realy apreciate
Regards
Dan
Hi there,
I have many files need import into mysql database. Unfortunately, the
date format in my csv file is mm/dd/, so is there a wordaround that
I don't need write another script to convert all my files?
Thanks.
Kevin
Hi,
If you use DBTools (http://dbtools.vila.bol.com.br), using the import text
wizard you have a lot of parameters to set, including date format and
separators. Unfortunatelly, runs only on windows platforms.
[]'s
Crercio
-Original Message-
From: Kevin Xin Lin [mailto:[EMAIL PROTECTED
Hello,
I would like to change the default date format MySql from /mm/dd to
dd/mm/. Does anyone know, how to make this change in MySql?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php
On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote:
Hello,
I would like to change the default date format MySql from /mm/dd to
dd/mm/. Does anyone know, how to make this change in MySql?
You can't.
However, you can select DATE, DATETIME, or TIMESTAMP values using
Thank paul. I know about Date_format, but was curious if there is some
setup parameters would allow us to define the MySql date format .
Paul DuBois wrote:
On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote:
Hello,
I would like to change the default date format MySql from
85 matches
Mail list logo