ASP SQL Server 2000 Date/Time Formating

[Chad S]

Hello,

I have two questions which I would appreciate some help with.

1. Date Formating when Inserting into SQL Server 2000
I'm currently passing YYYYMMDD into a datetime field. When I look at
the database it is in the format MM/DD/YYYY. However, if the date is
20040303 it's inserted as 3/3/2004. How do I keep the zero's in the
date when inserting into the database ?

2. Time Formating when Inserting into SQL Server 2000
I'm trying to insert military time to a datetime field. Is there a way
to format this in the database ? I've only had success using hh:mm
AM/PM. I only want to use military time.

Thank you so much !

Chad

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Jeff Cochran]

On Fri, 20 Feb 2004 09:48:51 -0800, Chad S <webaccess@hotmail.com>
wrote:

>I have two questions which I would appreciate some help with.
>
>1. Date Formating when Inserting into SQL Server 2000
>I'm currently passing YYYYMMDD into a datetime field. When I look at
>the database it is in the format MM/DD/YYYY. However, if the date is
>20040303 it's inserted as 3/3/2004. How do I keep the zero's in the
>date when inserting into the database ?
>
>2. Time Formating when Inserting into SQL Server 2000
>I'm trying to insert military time to a datetime field. Is there a way
>to format this in the database ? I've only had success using hh:mm
>AM/PM. I only want to use military time.

You need to understand that DateTime data types in SQL aren't stored
as any particular format. When you pass formatted date/time strings,
SQL may or may not get what you wish inserted into the field. You
format the date/time however you wish in the output, or rely on the
client settings for this.

See also:

[url]http://www.aspfaq.com/show.asp?id=2260[/url]

Jeff