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.
>>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
>>>plz suggest me somethingthanks for your help

Robert Chartier
Author, AspFree.com

  Return to Index