Buy Questpond's video subscriptions on
huge discount
.
Online: 2769
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Codes
>
Loading ...
To find first day of month.
Posted by
Omniitstudent
under
Sql Server
category on
2/18/2012
|
Points: 40
| Views : 2001
Post Code
|
Search Codes
|
Code Home
select DATENAME(DW,DATEADD(DD,-DATEPART(dd,getdate())+1,GETDATE()))
crazy code -->
Alert Moderator
Bookmark It
Comments or Responses
Posted by:
Pandians
on: 2/19/2012 Level:
Silver
| Status:
[Member]
[MVP]
|
Points: 10
Hi
Nice Try.
You can also try simply as follows
Select DateName(WEEKDAY,GETDATE() - DAY(GETDATE()) +1)
Posted by:
Samarmir
on: 2/21/2012 Level:
Starter
| Status:
[Member]
|
Points: 10
please provide an example of what it will return
Login to post response
Latest Code Snipptes
writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
More ...