Posted by Eugene Anthony on 03/16/07 02:16

This works.

SELECT DATEPART(mm, Dates) AS month,DATEPART(yy, Dates) AS year FROM
testing

Eugene Anthony

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Change connected user to avoid owner prefix in queries
• Prev in forum: Re: Query for Backup Model
• Thread view: Re: selecting records based on date

[Reply to this message]