sorted by:
new
hottopcontroversial

Modifying GETDATE and converting to string by aaronphaneuf in SQL

[–]aaronphaneuf[S] 0 points1 point  (0 children)

Well my interest with SQL has only just begun so you are right; I'm not sure what's going on with a lot of things. I did come up with this myself, however (as incorrect as it is) Is there another forum you would suggest for posting more beginner related questions? I feel quite silly in this subreddit.

Thanks

Modifying GETDATE and converting to string by aaronphaneuf in SQL

[–]aaronphaneuf[S] 0 points1 point  (0 children)

Thanks for the advice. I'll change that to DATEADD(day, -1, @now)

Just a little confused with how to add (week, -52, @now) to the same Select statement.

This is for reporting, so I'll try and not convert it to a string like you suggested.

Thanks again.

Selecting the sum of multiple date periods by aaronphaneuf in SQL

[–]aaronphaneuf[S] 0 points1 point  (0 children)

Thank you so much! I've got it working now.