select day(datecolumnname)as day from tablename
Query to get only day from particualar date
select day(datecolumnname)as day from tablename
Subscribe to:
Post Comments (Atom)
SQLQueriesCollection is blog for all sql queries in SqlServer at one place.SQL,SQL Query,SQL Queries,SQL Query Code,SQL Query Example,SQL Query Syntax,Basic Sql Queries,Query,SQL Examples,SQL Basic Queries,Structured Query Language.
0 comments:
Post a Comment