Re: sort by date
| From: | Petar Nedyalkov | Date: | Fri, 06 May 2005 07:28:14 +0000 |
| Subject: | Re: sort by date | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-214602@lists.php.net to get a copy of this message | ||
On Friday 06 May 2005 08:42, William Stokes wrote:
> Hello,
>
> I made a mistake and stored date information to DB as varchar values
> (dd.mm.yyy). When I read the DB is it still possible to sort the data by
> date with SQL query (ORDER BY date ASC)? Or is it nessessary to have the
> date information to be stored as a date in the DB? Will it work or is the
> output going to be sorted randomly?
All RDBMS have date formatting functions. Use them.
>
> Thanks
> -Will
--
Cyberly yours,
Petar Nedyalkov
Devoted Orbitel Fan :-)
PGP ID: 7AE45436
PGP Public Key: http://bu.orbitel.bg/pgp/bu.asc
PGP Fingerprint: 7923 8D52 B145 02E8 6F63 8BDA 2D3F 7C0B 7AE4 5436
Attachment: [application/pgp-signature]
Attachment: [application/pgp-signature]