Grokbase
Topics Posts Groups | in
x
[ help ]

tab view (ta...@hotmail.com)

Profile | Posts (1)

User Information

Display Name:tab view
Partial Email Address:ta...@hotmail.com
Posts:
1 total
1 in PostgreSQL - Novice

1 Most Recent Post

1) tab view forcing date ordering
| +1 vote
When I do the following piece of SQL SELECT DISTINCT to_char(datetimelogged,'dd/mm/yyyy') AS...
PostgreSQL - Novice
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
When I do the following piece of SQL

SELECT DISTINCT to_char(datetimelogged,'dd/mm/yyyy') AS datelogged FROM
logins ORDER BY datelogged DESC;

I don't seem to get the column sorted in date order. How do I force psql to
use date order?

Nige

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

spacer
Profile | Posts (1)
Home > People > tab view