Minh La wrote:
Hi, Can some help me with a date conversion problme
that I am having.
I have a date data in the following format:
'Month Days Year Hour:Minute AM/PM'
Example: 'Aug 21, 2004 2:00 PM'
So far the hours that I have spent have been in vain.
I tried using str_t
Minh La wrote:
So far the hours that I have spent have been in vain.
Next time a couple of minutes with the Fine Manual instead? :-)
I tried using str_to_date, but it keeps failing.
Looks like it's not in version 4.0.2?
Quoting the FM:
"STR_TO_DATE() is available as of MySQL 4.1.1."
FWIW,
--
Ha
Hi, Can some help me with a date conversion problme
that I am having.
I have a date data in the following format:
'Month Days Year Hour:Minute AM/PM'
Example: 'Aug 21, 2004 2:00 PM'
So far the hours that I have spent have been in vain.
I tried using str_to_date, but it k
Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 29, 2004 12:27 PM
To: Christopher L. Hood; '[EMAIL PROTECTED] '
Subject: RE: Date Conversion Function
I do not know of an MM() date function in MS SQL, only mm used for the
date
part. What are you att
I do not know of an MM() date function in MS SQL, only mm used for the date
part. What are you attempting to accomplish?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 7/29/04 11:17 AM
Subject: Date Conversion Function
M$ SQL server has a function MM that will do
ql.com/doc/mysql/en/Date_and_time_functions.html
-- Original message from [EMAIL PROTECTED]: --
> M$ SQL server has a function MM that will do some date conversion, is
> there an equivalent in MySQL ??
>
--
MySQL General Mailing List
For list archives: htt
M$ SQL server has a function MM that will do some date conversion, is
there an equivalent in MySQL ??
Chris Hood
Investigator Verizon Global Security Operations Center
Email: [EMAIL PROTECTED]
Desk: 972.399.5900
Verizon Proprietary
NOTICE - This message and any attached files may
found out that 4.0 has a date format converter
thanks for the Perl
actually I wrote a Qt/C++ program to convert the date
_
Worried about inbox overload? Get MSN Extra Storage now!
http://join.msn.com/?PAGE=features/es
--
MySQL Ge
e date string you want to have converted (e.g. via a
variable from an API or a column name from a
select/update/insert..select
Cheers
/rudy
-Original Message-
From: Jonathan Patton [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 15:07
To: [EMAIL PROTECTED]
Subject: date conversion
I
I need to convert dates in the format below into mysql date format. If I try to change
the column type to date, it wipes out the data.
+-+
| 26-Jan-2001 |
| 26-Jan-2001 |
| 15-Apr-2001 |
| 1-Nov-2001 |
| 31-Oct-2001 |
| 26-Jan-2001 |
| 22-Jun-2001 |
| 23-Jul-2000 |
| 1-Nov-2001 |
|
"+dArray[0]+"-"+dArray[1];//MM/DD/
return rDate
}
- Original Message -
From: "Dana Shields" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 5:13 PM
Subject: Date Conversion with UltraDev (ASP)
> I am using MySQL with Ult
ht and not by
volume.
- Original Message -
From: "Dana Shields" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 08, 2003 9:13 AM
Subject: Date Conversion with UltraDev (ASP)
I am using MySQL with Ultradev (asp server model), and I'm creating
I am using MySQL with Ultradev (asp server model), and I'm creating a
recordset insert form; however, the documenation is obvious that the user
has to enter the date in -mm-dd format. However, this will not work for
my users, and I need to allow them to enter mm/dd/ or even mm/dd/yy
format.
I am using MySQL with Ultradev (asp server model), and I'm creating a
recordset insert form; however, the documenation is obvious that the user
has to enter the date in -mm-dd format. However, this will not work for
my users, and I need to allow them to enter mm/dd/ or even mm/dd/yy
format.
You need to convert the date format to:
-MM-DD:
http://www.mysql.com/doc/en/Using_DATE.html
At 08:38 PM 12/8/2002 -0500, [EMAIL PROTECTED] wrote:
Hi all,
I have a datetime data field in SQLServer7, and I am trying to get a
recordset according to criteria that the CallDate field in the da
Hi all,
I have a datetime data field in SQLServer7, and I am trying to get a recordset
according to criteria that the CallDate field in the database equals todays date
09/12/2002
Dim TodaysDate
TodaysDate= cDate(Date)
sCallsSQL = "SELECT
CallBacks.CallDate,CallBac
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Friday, 22 November 2002 13:01
To: MYSQL
Subject: date conversion problem
Hey All,
I'm storing date values for hockey game information using the
DATE value and
they are stored as MMDD and when I re
this might give you some ideas
select
CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV
E)) DATEGOLIVEF
from my table p
> -Original Message-
> From: Alex Behrens [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 22 November 2002 13:0
Hey All,
I'm storing date values for hockey game information using the DATE value and
they are stored as MMDD and when I retrieve them from the database they
are shown as: "2002-11-23" I was wondering if there was a way to have them
converted to November, 23, 2002 when they are displayed on my
Paul DuBois wrote:
> At 9:27 AM -0300 9/6/01, Amilton Martins wrote:
> >I want to write date type in the format "DD/MM/" to the database?
> >Can I do this with some parameter to mysql.ini?
>
> No. For storage, you must convert it to CCYY-MM-DD format.
> For display, you can format it to the
At 9:27 AM -0300 9/6/01, Amilton Martins wrote:
>I want to write date type in the format "DD/MM/" to the database?
>Can I do this with some parameter to mysql.ini?
No. For storage, you must convert it to CCYY-MM-DD format.
For display, you can format it to the style you want using
DATE_FORMA
No.
Amilton Martins wrote:
> I want to write date type in the format "DD/MM/" to the database?
> Can I do this with some parameter to mysql.ini?
>
> **
> Amilton Martins
> Infosoft Informática Ltda.
> www.infosoft.inf.br
>
>
> -
I want to write date type in the format "DD/MM/" to the database?
Can I do this with some parameter to mysql.ini?
**
Amilton Martins
Infosoft Informática Ltda.
www.infosoft.inf.br
-
Before posting,
23 matches
Mail list logo
