p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: date format problem plz help!!!


Message #1 by "Taher Moiyed" <taherm@f...> on Wed, 6 Jun 2001 15:42:45
IMHO, this would be considered as business logic, and as all of us know,
business logic should be kept out of the database.

(what happens when you want to internationalize & localize?)




At 06:59 PM 6/6/2001 +0100, you wrote:
>why not do all this in your SQL it will be quicker to do and stops you
>having to remember to do this conversion afterwards if you update your
>code later, check out the to_date and to_char functions.
>
>At 08:00 06/06/01 -0700, you wrote:
>>Take a look at some of the date formatting functions available.
>>
>>formatdatetime() is a good place to start.
>>
>>http://www.aspfree.com/devlinks/search.asp?file404=3Dformatdatetime#VBScri
pt_Documentation
>>
>>
>>or else, the string handling functions
>>
>>mid() left() right() etc...
>>
>>
>>
>>
>>At 03:42 PM 6/6/2001 +0000, you wrote:
>>>i have this code on my asp page
>>>
>>><%=3DDoDateTime((Recordset1.Fields.Item("DomainExpiryDate").Value), 1,
 -1) %>
>>>
>>>this displays date in the following format
>>>1 September 2001
>>>
>>>but i want the date to be displayed in
>>>1 Sep 2001
>>>
>>>which is medium format in access db. i am using ultradev as my coding
>>>environment.
>>>
>>>plz suggest me somethingthanks for your help


Robert Chartier
Author, AspFree.com
xxx-xxx-xxxx
rob@a...
http://www.aspfree.com/devlinks
http://www.aspfree.com/authors/robert
http://www.aspalliance.com/nothingmn


  Return to Index