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:
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
mysql select date_sub(curdate(), interval 1 day) as wibble;
++
| wibble |
++
| 2003-06-30 |
++
1 row in set (0.00 sec)
-Original Message-
From: Fabio Bernardo [mailto:[EMAIL PROTECTED]
Sent: Tuesday 01 July 2003 15:32
To: Mysql (E-mail)
Subject:
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
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 into
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.
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
Hi,
My opinion:
You can create char field type on table (i.e. char(10)) and when you wish to
do some date comparison you can use the next mySQL
functions:LEFT,MID,RIGHT,TRIM (is not only in VB)
I.E:
mydate-field in a_table:char(10);
date on this field: '10.01.2001','30.01.2000',...etc.
select *
, 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
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
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
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
On Thu, 28 Jun 2001 21:49:57 +0200, Sebastiaan J.A. Kamp [EMAIL PROTECTED]
wrote:
if your using perl, heres a real simple way to format your date:
my $date = 28/06/2001;
my($mn,$day,$yr) = split '/',$date;
my $db_date = join('-',$yr,$mn,$day);
# Your output should now be $db_date = 2001-06-28
20 matches
Mail list logo