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
>>>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