That is what the TO_CHAR() function does. Using it results in no output (empty table cells) with the display taglib, tho.
Keith ---------- Original Message ----------- From: "Karl Coleman" <[EMAIL PROTECTED]> To: "Tag Libraries Users List" <[EMAIL PROTECTED]> Sent: Mon, 16 Aug 2004 13:20:06 -0400 Subject: RE: Display Taglib & Dates > I know T-SQL on MS SQL Server has functions that allow for date formatting. Maybe something similar exists for Oracle. > > Karl > > -----Original Message----- > From: Keith [mailto:[EMAIL PROTECTED] > Sent: Monday, August 16, 2004 1:18 PM > To: Taglibs > Subject: Display Taglib & Dates > > I just got the Display taglib to try and make some of my job a little easier. Things > seemed to be going good til I ran across the problem of a date field. I'm pulling > from an > Oracle database, so the following query: > > <sql:query var="projects"> > SELECT a.project_id, > a.project_name, > a.kickoff_date > FROM project_main a > ORDER BY project_id DESC > </sql:query> > > returns something like this: > > 10016 > Project1234 > 2004-07-15 00:00:00.0 > > I'd like to format the date field to look like this: 15-Jul-2004 > Before, I just used the <fmt:formatDate> tag, but I'm at a loss for how to use it in > conjuction with the display taglib. I tried using the TO_CHAR function in the > database > query to format my date beforehand, but then it doesn't return any date information > at > all. Any help? > > Keith > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] ------- End of Original Message ------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
