make it likeSELECT LOGGED_IN_USER_ID,cast(DATEADD(dd,(5.5/24),MIN((EVENT_TIME))) as date)AS LOGINDATE,SUBSTRING((Min(EVENT_TIME)),12,22) AS LOGINTIME FROM dwh_staging..SSO_AUDIT_TBL WHERE EVENT_ID = 'LOGIN' AND EVENT_TIME BETWEEN '20130215' AND '20130216' GROUP BY LOGGED_IN_USER_ID
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/