juststeve
asked on
append AM or PM
I'm building a field that holds a TIME value by:
.
.
.
DATENAME(hh, wDate) + ':' + DATENAME(mi, wDate) as myTime,
.
.
I'd like to add an 'am' or 'pm' to the string but don't see that as an option for either DATENAME or DATEPART
.
.
.
DATENAME(hh, wDate) + ':' + DATENAME(mi, wDate) as myTime,
.
.
I'd like to add an 'am' or 'pm' to the string but don't see that as an option for either DATENAME or DATEPART
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.