| Author |
Convert Access 2003 Function
|
|
|
| I am converting an Access DB to SQL2000 and opne of the queries uses the
Format$ function. How should the syntax be for SQL?
Access: Format$(TimeTrackerE
ntry.EntryDate,'yyyymm') AS EntryMonth
| |
| Jerry Spivey 2005-09-30, 1:23 pm |
| Use the CONVERT function with an optional date style argument. See the
following for syntax, samples and date arguments.
http://msdn.microsoft.com/library/d..._ca-co_2f3o.asp
HTH
Jerry
"dj5md" <dj5md@discussions.microsoft.com> wrote in message
news:073E808D-100D-4F1F-9842- 4BEB4DF3F112@microso
ft.com...
>I am converting an Access DB to SQL2000 and opne of the queries uses the
> Format$ function. How should the syntax be for SQL?
>
> Access: Format$(TimeTrackerE
ntry.EntryDate,'yyyymm') AS EntryMonth
| |
|
| Thanks Jerry, I already looked at Cast and Convert but cannot figure out the
correct syntax. It's a bit confusing for me.
"Jerry Spivey" wrote:
> Use the CONVERT function with an optional date style argument. See the
> following for syntax, samples and date arguments.
>
> http://msdn.microsoft.com/library/d..._ca-co_2f3o.asp
>
> HTH
>
> Jerry
> "dj5md" <dj5md@discussions.microsoft.com> wrote in message
> news:073E808D-100D-4F1F-9842- 4BEB4DF3F112@microso
ft.com...
>
>
>
| |
| Jerry Spivey 2005-09-30, 1:23 pm |
| Try this:
SELECT LEFT(CONVERT(VARCHAR
(25),GETDATE(),112),
6)
HTH
Jerry
"dj5md" <dj5md@discussions.microsoft.com> wrote in message
news:8212D4FC-A530-47DC-9E07- 934516904C6D@microso
ft.com...[color=darkred]
> Thanks Jerry, I already looked at Cast and Convert but cannot figure out
> the
> correct syntax. It's a bit confusing for me.
>
> "Jerry Spivey" wrote:
>
| |
|
| Thats was it. I changed the GetDate with my DB field and removed the Select
and it worked with no problems. Thanks much Jerry. I also understand the
function better now that I have the correct syntax.
"Jerry Spivey" wrote:
> Try this:
>
> SELECT LEFT(CONVERT(VARCHAR
(25),GETDATE(),112),
6)
>
> HTH
>
> Jerry
> "dj5md" <dj5md@discussions.microsoft.com> wrote in message
> news:8212D4FC-A530-47DC-9E07- 934516904C6D@microso
ft.com...
>
>
>
|
|
|
|