Sql query to replace date
Closed
sidhu
-
Sep 3, 2010 at 11:44 PM
wingamer Posts 5 Registration date Friday January 7, 2011 Status Member Last seen January 7, 2011 - Jan 7, 2011 at 06:08 AM
wingamer Posts 5 Registration date Friday January 7, 2011 Status Member Last seen January 7, 2011 - Jan 7, 2011 at 06:08 AM
Related:
- Sql replace date
- Oracle sql datediff - Guide
- Sql dbx - Download - IDE
- How to replace a word in word - Guide
- How to avoid duplicate records in sql select query - Guide
- Export diagram sql server - Guide
1 response
wingamer
Posts
5
Registration date
Friday January 7, 2011
Status
Member
Last seen
January 7, 2011
Jan 7, 2011 at 06:08 AM
Jan 7, 2011 at 06:08 AM
Please try this
select [YEAR] = YEAR([date]), [MONTH] = MONTH([date]), [DAY] = DAY([date]), * from dates