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