Preview Content - log in or become a member

t-sql first day of previous month

If you are after T-SQL First Day of Previous Month calculation then you are in the right place.

To return first day of previous month using T-SQL we can use the following statement:

Below is a visual representation of the logic I want to use to get first day of previous month and below the picture is the explanation.

First Day of Previous month



For full access Log In or become a member

Plans:
Bronze
Silver
Gold
6 Courses
T-SQL (3), SSRS (1), SSIS(1), Excel (1)
Watch Video
75 Mini Courses
T-SQL (34), SSRS (7), SSIS(16), + more
300+ videos and 300+ Articles
38
(part of
Courses)
Progress Tracking
21 Interview Q&As pages
T-SQL (8), SSRS (3), SSIS(4), Other (6)
Forum
11 Webinar Recordings
T-SQL (1), SSRS (9), Career(1)
1 DIY Project (beta)
70-461 Tests
Watch Video
60 days, 100% Money Back Guarantee
Instant Activation
Currency: USD*
* You can change currency at checkout.
Duration:
Bronze
Silver
Gold
1 month $19
sign up
$24
sign up
$29
sign up
3 months 33% off
(2 months + 1 free)
$39
sign up
$50
sign up
$60
sign up
6 months 40% off
(3.6 months + 2.4 free)
$68
sign up
$86
sign up
$104
sign up
1 year 50% off
(6 months + 6 free)
$114
sign up
$144
sign up
$174
sign up
2 years 60% off
(9.6 months + 14.4 free)
$182
sign up
$230
sign up
$278
sign up
lifetime >60% off
(12.5 months + a lot for free)
$239
sign up
$302
sign up
$365
sign up


Did you find this page useful?
+3  |  -0
(3 Votes)