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

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...br />
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... />
o_2f3o.asp
>
> HTH
>
> Jerry
> "dj5md" <dj5md@discussions.microsoft.com> wrote in message
> news:073E808D-100D-4F1F-9842- 4BEB4DF3F112@microso
ft.com... 
>
>
>

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