|
 |
asp_web_howto thread: how to display date in dd/mm/yyyy format
Message #1 by "Krishnanand K, J16 Chennai" <krishnanandk@m...> on Tue, 20 Feb 2001 14:05:21 +0530
|
|
Hello all,
I want to display the date field in dd/mm/yyyy format in a ASP page
which is stored in the sqlserver in mm/dd/yyyy format.
FormatDateTime function is not giving the solution.
Any help.
With regards
krishna
Message #2 by Gregory_Griffiths@c... on Tue, 20 Feb 2001 12:12:04 +0000
|
|
you should be able to do this in you SQL try something like
to_char(mydate,'mm/dd/yyyy')
> -----Original Message-----
> From: krishnanandk@m...
> [mailto:krishnanandk@m...]
> Sent: 20 February 2001 08:35
> To: asp_web_howto@p...
> Cc: krishnanandk@m...
> Subject: [asp_web_howto] how to display date in dd/mm/yyyy format
>
>
>
> Hello all,
> I want to display the date field in dd/mm/yyyy format
> in a ASP page
> which is stored in the sqlserver in mm/dd/yyyy format.
> FormatDateTime function is not giving the solution.
> Any help.
> With regards
> krishna
>
|
|
|
View Cart
