|
MattC
Starting Member
USA
9 Posts |
 Posted - 12/20/2012 : 10:11:21
|
I have a simple query:
SELECT timezone_id,city_id,state_id
FROM city
WHERE (city_id = 'ANCHORAGE' AND state_id = 'AK')
in MS SQL Server Management Studio it returns:
timezone_id city_id state_id
US/Alaska, ANCHORAGE, AK
But in Toad it returns:
timezone_id city_id state_id
{null}, ANCHORAGE, AK
Notice that Toad returns a timezone value of "{null}" but Mgnt Studio return the correct value "US/Alaska"
Any ideas or suggestions?
Thanks in advance,
Matt |
|
Works in Management Studio but not Toad
