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_to_date, but it keeps failin
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
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
Not being an MSSQL expert, I don't know what MM does, and since you did not specify
what type of conversions you wish to perform, I can't say exactly which function would
suit your needs, but here is a link to the manual page that lists all date and time
functions --
http://dev.mysql.com/doc/my
SELECT concat( substring_index(DATE,'-',-1),
'-',
lpad(
field(substring_index(substring_index(DATE,'-',2),'-',-1),
'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug',
'Sep','Oct','Nov','Dec'),
2,'0'),
With UltraDev you still have to call some javascript.
Here is a couple of examples...
function MySQLDateToday(){
var tDate = new Date();
year = tDate.getFullYear();
month = tDate.getMonth() + 1;
if (month < 10)
{ month = "0" + month; }
day = tDate.getDate(); //getDate is day of month, go fi
you could use the format function of vbScript
format(string, "-mm-dd")
The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
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
At 13:11 +1100 11/22/02, Alan McDonald wrote:
this might give you some ideas
select
CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV
E)) DATEGOLIVEF
from my table p
It's a little easier to use DATE_FORMAT(d,'%M, %d, %Y') instead.
-Original Message-
From:
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:01
> To: MYSQL
> Subject: date convers
11 matches
Mail list logo
