Yeah, but it inserts PM or AM also.. so the insert is over 19 chars.. =/
--
MVH, Martin Johansson
CEO & Project Supervisor
SD-Studios, Squaremedia HB
+46 (0)70-3003320
http://www.sd-studios.com
http://www.swehost.com


-----Ursprungligt meddelande-----
Från: Kim Iwan Hansen [mailto:kimiwan@k...]
Skickat: den 9 juli 2002 21:29
Till: ASP Databases
Ämne: [asp_databases] RE: Storing values in a sqlserver 2000 DateTime
field (WAS: Returning only date fields with a value)


I'm not sure I understand your problem.  A DateTime already holds both date
and time (unless you only supply a date, in which case it'll store the time
as 00:00:00.000).

The DateTime field stores the value as YYYY-MM-DD hh:mm:ss.msmsms

Isn't that what you want?

-Kim


> -----Original Message-----
> From: SD-Studios [mailto:info@s...]
> Sent: 9. juli 2002 20:53
> To: ASP Databases
> Subject: [asp_databases] SV: Returning only date fields with a value
>
>
> Hi!
> I am currently running MS SQL Server 2000. Is there a way to make the
> datetime-field longer, so that it can contain both date and
> time..? Thanks!
> --
> MVH, Martin Johansson
> CEO & Project Supervisor
> SD-Studios, Squaremedia HB
> +46 (0)70-3003320
> http://www.sd-studios.com
> http://www.swehost.com
>
>