1. How do I retrieve todays date in the format of mm/dd/ccyy
2 If I have a date that was stored using the getdate function in format mm/dd/ccyy hh:mm:ss am or pm,
how do I retrieve only the mm/dd/ccyy portion of the date.
I am trying to read in a message of the day message that was meant to be displayed today? I am using sql 2000.
where pull only mm/dd/ccyy data from startdate >= todays date mm/dd/ccyy and pull only mm/dd/ccyy data for enddate <= todays date mm/dd/ccyy
startdate format of getdate mmdd/ccyy hh:mm:ss pm or am
enddate format of getdate mm/dd/ccyy hh:mm:ss pm or am