datetime function

Adam H-W · July 14th, 2005, 11:18 AM

Hi there

Is it possible to pull out part of the string from a datetime column in SQL - i.e if I just wanted to pull out the month, how would I do it?

thanks

Adam

DaveGerard · July 14th, 2005, 11:38 AM

Month(MyDate)

Adam H-W · July 14th, 2005, 11:53 AM

Great, thanks - 1 more thing on this topic.

I've built some asp pages to enter the date in; if I want to put at the top of dates in July - 'July' and the same for August etc, (just to differentiate the months) how would I go about it?

thanks

Adam

Adam H-W · July 15th, 2005, 03:00 AM

Further to this, how do you write the day and the year i.e like pullling out the month as so:

<%=MonthName(Month( strDateString ))%>

what would be the same but for the year and the day?

thanks

Adam

happygv · July 19th, 2005, 04:49 PM

For Year it is Year(strDateString)
and for Day it is Day(strDateString)

Hope that helps.
Cheers

_________________________
- Vijay G
Strive for Perfection

Adam H-W · July 23rd, 2005, 02:24 AM

thanks VJ