SQL statement query date View Different Different Different Methods Access: "Select * from yourtable where Datefield = # 1998/12/10 #", Date must be added to SQL Server: "SELECT * from Yourtable Where Datafield = 'July 10 The 1998 'date is used as a string if the date format is used in the format of YY / MM / DD or YYYY / MM / DD, and the second sequence should be determined according to the server setting.