Hi,

How can I convert a value created from DateTime.Now() to the datetime
format that SQL Server recognises?


Thanks in advance.

You could use .ToString() and provide format specifiers, such as

DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss.ffffff")


--

BlackWasp
www.blackwasp.co.uk


<(E-Mail Removed)> wrote in message
news:900b5003-a554-47b9-b782-(E-Mail Removed)...
> Hi,
>
> How can I convert a value created from DateTime.Now() to the datetime
> format that SQL Server recognises?
>
>
> Thanks in advance.
>

.....except use HH, not hh to get 24-hour clock times.

DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.ffffff")

--

BlackWasp
www.blackwasp.co.uk


"BlackWasp" <nospam@please> wrote in message
news:%23Y$(E-Mail Removed)...
> You could use .ToString() and provide format specifiers, such as
>
> DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss.ffffff")
>
>
> --
>
> BlackWasp
> www.blackwasp.co.uk
>
>
> <(E-Mail Removed)> wrote in message
> news:900b5003-a554-47b9-b782-(E-Mail Removed)...
>> Hi,
>>
>> How can I convert a value created from DateTime.Now() to the datetime
>> format that SQL Server recognises?
>>
>>
>> Thanks in advance.
>>
>

On Wed, 6 Feb 2008 10:43:49 -0800 (PST), (E-Mail Removed) wrote:

>Hi,
>
> How can I convert a value created from DateTime.Now() to the datetime
>format that SQL Server recognises?
>
>
> Thanks in advance.

You could supply the datetime as a parameter.