Helpful Information
Home
Categories
Contact us
Category: Client & Server Side Scripting (PHP, ASP, JavaScript)
SQL selection against month of a date field: HTML, CSS, JavaScript, PHP
Hi ,
Can I do the below?
strSQL = "SELECT * FROM comments where portal='"&portalName&"' and Month(entryDate)="&Cint(sMonth)
entryDate is a date field in the table
sMonth is a passed variable of value 1-12
If not, How do I in the selection of records reference the month part of a date field.
Cheers.
Steve
privacy (GDPR)