MS SQL

RSS

Get last month from timestamp

Please support our MS SQL advertiser: Programming Forums

Thread Solved

•

Posts: 305

Reputation: freshfitz is an unknown quantity at this point

Solved Threads: 23

freshfitz

Offline

Posting Whiz

Get last month from timestamp

Jan 1st, 2009

How would I select everything from last month in a sql statment my cell has a time stamp in it

Help with Code Tags

(Toggle Plain Text)

SELECT DateTimeStamp
from Get_estimates

Ouput

[DateTimeStamp]
2008-02-28 11:39:35.247
2008-03-09 13:15:12.513
2008-03-09 13:16:53.700
2008-03-26 13:30:20.077
2008-03-26 13:30:51.810

Last edited by freshfitz : Jan 1st, 2009 at 2:50 pm.

http://Vortexamerica.com

•

Posts: 1,867

Reputation: Ramy Mahrous has a spectacular aura about

Solved Threads: 214

Ramy Mahrous Ramy Mahrous is offline

Offline

Posting Virtuoso

Re: Get last month from timestamp

Jan 1st, 2009

So the output should be
2008-03-09 13:15:12.513
2008-03-09 13:16:53.700
2008-03-26 13:30:20.077
2008-03-26 13:30:51.810

right?

BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous

•

Posts: 305

Reputation: freshfitz is an unknown quantity at this point

Solved Threads: 23

freshfitz

Offline

Posting Whiz

Re: Get last month from timestamp

Jan 1st, 2009

I want to display all the orders from last month so

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT *
FROM Get_estimates
WHERE DateTimeStamp = [lastmonth]
SELECT *
from Get_estimates
where DateTimeStamp = [lastmonth]

Last edited by peter_budo : Jan 6th, 2009 at 8:21 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

http://Vortexamerica.com