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
pgpLxsPbcV9bg.pgp
Description: PGP signature
