SQL help
SQL help
- Started
- Last post
- 8 Responses
- ********
I need to order a result first by DATE then those results by TIME.
ORDER BY date AND time ASC
is giving me unexpected results...
Anyone please?!
- unfittoprint0
use commas instead:
ORDER BY date, time ASC
- ********0
Didn't work.
- ********0
check formatting oan date an' time??
- ********0
http://www.determinedmoth.org/!s…
Does that help?
- mxhxr100
select * from tableName
order by DATE, TIME ascNulls and empty string will come first. This should work.
Your friendly neighborhood DBA.
- gabriel20
also be careful to watch for using reserved words for query variables...
- ********0
No. The result I get from
order by DATE, TIME asc
is the same as
order by DATE