How to query the date type of date type in ASP

zhaozj2021-02-08  244

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.

转载请注明原文地址:https://www.9cbs.com/read-1457.html

New Post(0)