How to display a date in a certain format? 1

[scottew]

I am trying to display the date in a certain format. In SQL, I have the field defined as datetime and 8 characters.

I have the following in the output...

<tr><td width="90%" height="18" colspan="3" class="eventDateHeader"><b>#getEvent.eventDate#</b></td></tr>

And it is displayed as 2008-10-02 00:00:00.0

How can I get it to be displayed as October 10, 2008?

Thanks in advance.
Scott

 

[minli98]

Use dateformat. See

http://livedocs.adobe.com/coldfusio...xt=ColdFusion_Documentation&file=00000441.htm

In your example, it would be

#dateformat(getEvent.eventDate,"mmmm d, yyyy")#

 

[scottew]

Thanks minli98, that did it.