Dates ...

[fatherjack]

why does this sql return the dates in different formats? Is it a default setting on the server or do i just handle it on SQL?

use northwind

select top 20 orderdate from orders

select top 20 left(orderdate,10) from orders


thanks

fatherjack

[skhanal]

When you used LEFT function SQL did implicity conversion of date to character.


select top 20 cast(orderdate as varchar) from orders

will show the same effect.