RE: MYSQL date format: msg#00067 cms.cold-fusion.user.azcfug

------=_NextPart_000_001D_01BFF0D1.D55EE3A0 Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Marlene,
What is the exact value that the query is returning?

- John
-----Original Message-----
From: Marlene Buffa [mailto:mbuffa@xxxxxxxxxxxxx]
Sent: Tuesday, July 18, 2000 3:58 PM
To: azcfug-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx
Subject: [azcfug] MYSQL date format

I am trying to display mmmm, mm, dd, yyyy

using a timestamp from a MYSQL db

I can get the day of the week to appear in words (but it is the
wrong day), and the rest of the values show up as 66535, 66535,
66535.

huh?

any clue how to format this? I've tried every configuration in
WACK and the MYSQL book.

marlene

----------------------------------------------------------------------------
--

----------------------------------------------------------------------------
--
To unsubscribe from this group, send an email to:
azcfug-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx

------=_NextPart_000_001D_01BFF0D1.D55EE3A0 Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dus-ascii" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D764280323-18072000>Marlene,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN class=3D764280323-18=
072000>What=20
is the exact value that the query is returning?</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D764280323-18072000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN class=3D764280323-18=
072000>-=20
John</SPAN></FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5p=
x">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT face=3DTah=
oma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Marlene Buffa=20
[mailto:mbuffa@xxxxxxxxxxxxx]<BR><B>Sent:</B> Tuesday, July 18, 2000 =
3:58=20
PM<BR><B>To:</B>
azcfug-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx<BR><B>Subject:</B> [azcfug]
MYSQL dat=
e=20
format<BR><BR></DIV></FONT><TT>      I am trying=
to=20
display mmmm, mm, dd, yyyy<BR><BR>      using a=
=20
timestamp from a MYSQL db<BR><BR>      I can get=
the=20
day of the week to appear in words (but it is the <BR>wrong day), and the=
rest=20
of the values show up as 66535, 66535,=20
<BR>66535.<BR><BR>     =20
huh?<BR><BR>      any clue how to format this? I=
've=20
tried every configuration in <BR>WACK and the MYSQL=20
book.<BR><BR>      marlene<BR></TT><TT>To unsubs=
cribe from this group, send=20
an email=20
to:<BR>azcfug-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx<BR><BR></TT><BR></BLOCKQUOTE></BODY><=
/HTML>
------=_NextPart_000_001D_01BFF0D1.D55EE3A0--

Previous by Date:	MYSQL date format: 00067, Marlene Buffa
Next by Date:	RE: MYSQL date format: 00067, Marlene Buffa
Previous by Thread:	MYSQL date formati: 00067, Marlene Buffa
Next by Thread:	RE: MYSQL date format: 00067, Marlene Buffa
Indexes:	[Date] [Thread] [Top] [All Lists]