I have the query that looking into a date. the sql looks at the condition where date <= 'date from the database'. I have 1 client that located in California (PST) and when he look at the recordset is nbot working for him. How would I say in sql to look at the localTime.
FOr example, the database is set to hjave startDate <= '7/1/2015' if I am in the east cost 12:00AM it is 7/2/12015 but in the west cost it is 9:00PM