sql server date stored in table comparing with the system date -

sql server date stored in table comparing with the system date -

really struggling convert below date format 10.11.2013 in format of scheme date.

i have request compare column info scheme date. in column date storing dd.mm.yyyy

or need convert scheme date (getdate()) date values stored in database table.

thanks in advance

regards, dev

try this:

convert scheme date (getdate()) date values stored in database table.

gives formats dd.mm.yyyy

select convert( char(10),getdate(),104) -- outputs 11.09.2014

with column

select convert( char(10),mycolumn,104)

sql-server date-conversion