|
Home > Archive > MS SQL Server New Users > November 2005 > updating field with specific date?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
updating field with specific date?
|
|
|
| How do I update a date field to reflect a specific date? My field is
formatted at smalldatetime.
I've tried:
UPDATE dbo.Dealers
SET dbo.Dealers.BillQ2 = 2005/11/14
FROM dbo.Dealers, aipdn.qtr2
WHERE dbo.Dealers.DealerCode = aipdn.qtr2.DealerCode
And I've tried it as 11/14/2005 also.
??
| |
|
| Nevermind - just got it. = '20051114'
"r" <r@r.com> wrote in message news:uKTaIq76FHA.268@TK2MSFTNGP10.phx.gbl...
> How do I update a date field to reflect a specific date? My field is
> formatted at smalldatetime.
>
> I've tried:
>
> UPDATE dbo.Dealers
> SET dbo.Dealers.BillQ2 = 2005/11/14
> FROM dbo.Dealers, aipdn.qtr2
> WHERE dbo.Dealers.DealerCode = aipdn.qtr2.DealerCode
>
> And I've tried it as 11/14/2005 also.
>
> ??
>
>
>
|
|
|
|
|