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: [
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
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 Wh
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
(i
"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 form
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 f
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: d
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
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.
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 displ
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 *
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
Fax: +49-30-46307-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
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 dat
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
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 fo
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:
>http
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-0
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_FORM
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
20 matches
Mail list logo
