Change Date from mm/dd/yyyy to dd - mm

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

Change Date from mm/dd/yyyy to dd - mm

Author

Topic

danjapro
Starting Member

44 Posts

Posted - 2006-10-11 : 14:57:00

I need to change my code to read my date from mm/dd/yyyy to DD - MM

CODE:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

<%

do while not rs.EOF

':: read db record
on error resume next
DateAdded = rs("DateAdded")
on error goto 0

%>

<tr>
<td class='SectionTDNews'>

<% DateAdded = left(DateAdded,4) %><% title = left(title,22) %><a href="content.do?contentid=<% =ContentId %>" class='SectionFontNews'><% =DateAdded %> - <img src="styles/nse/images/edit-m-stx-xx.gif" border="0"> <% =Title %></a>..
</td>
</tr>

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-10-11 : 15:00:03

day(DateAdded) & " - " & month(DateAdded)

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources