Brian Gubb
|
Posted: 03/28/2003, 3:08 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C2F57E.EB10B3E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Can someone tell me the trick in getting a list box to display in =
dd/mm/yyyy format.
Using sql=20
Select distinct gamedate from table
TIA
Brian
------=_NextPart_000_0008_01C2F57E.EB10B3E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2723.2500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Can someone tell me the trick in getting a list box =
to display=20
in dd/mm/yyyy format.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Using sql </FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Select distinct gamedate from table</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>TIA</FONT></DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BODY></HTML>
------=_NextPart_000_0008_01C2F57E.EB10B3E0--
|
|
|
PJ
|
Posted: 03/28/2003, 9:09 AM |
|
SELECT DISTINCT DATE_FORMAT(gamedate, '%D %M %Y') from table
will return 14th July 2003 for example
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:b61af2$v77$1@news.codecharge.com...
Can someone tell me the trick in getting a list box to display in dd/mm/yyyy
format.
Using sql
Select distinct gamedate from table
TIA
Brian
|
|
|
PJ
|
Posted: 03/28/2003, 9:14 AM |
|
Sorry, for a tidy result use this......
SELECT DISTINCT DATE_FORMAT(gamedate, '%D %M %Y') AS gamedate from table
"PJ" <apis@globalnet.co.uk> wrote in message
news:b61vjq$i39$1@news.codecharge.com...
> SELECT DISTINCT DATE_FORMAT(gamedate, '%D %M %Y') from table
>
> will return 14th July 2003 for example
>
>
> "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
>news:b61af2$v77$1@news.codecharge.com...
> Can someone tell me the trick in getting a list box to display in
dd/mm/yyyy
> format.
>
> Using sql
>
> Select distinct gamedate from table
>
> TIA
> Brian
>
>
|
|
|
|