Overview of SQL Server Data Types: Time Zone Aware Dates

[hassax1966]

God bless you !!

[abdulhkhan]

Hi There wondering if you can help with my query. I am trying to get the current date but nothing seems to work unless I specify the date myself, please see below query, appreciate any help.

SELECT UNIQUE last_name, reader_desc,xact_date,xact_tim­e

FROM badge_history

WHERE xact_date="20111206" AND

(badge_history.reader_desc="DO­OR 1"

OR

badge_history.reader_desc="DOO­R 2")

ORDER 1,4