selecting total amount consumed yesterday


Hello there,

SELECT      timestamp
     , "kWh del"
     , "kWh rec"
     , "kWh del-rec"

  FROM   --(*vendor(PML),product(LogServer) EgyDmd Log@ALI.7600 *)--

  WHERE  (timestamp <= today_12AM()
         AND
        timestamp >= yesterday())

  ORDER BY timestamp DESC
 --  SQL generated with ION Enterprise version 5.5 build 318

What operation should i use to get the total energy consumed yesterday. I am querying it from a remote meters database.The above operation is giving me energy consumed every 15min for the whole day.But i want to see the total energy consumed .
Please help!!!Its urgent......I am not a SQL guru but more of a hardware guy.
Thank you
zolfAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
this will give you yesterday
SELECT CONVERT(varchar(10),GETDATE()-1,120)

SELECT      timestamp
     , "kWh del"
     , "kWh rec"
     , "kWh del-rec"

  FROM   --(*vendor(PML),product(LogServer) EgyDmd Log@ALI.7600 *)--

  WHERE  CONVERT(varchar(10),urDatetimeColumn-1,120)    = CONVERT(varchar(10),GETDATE()-1,120)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bruintjeCommented:
Hello zolf,

you could try
---------
  SELECT SUM("kWh del") AS TotalKwhDel
     , SUM("kWh rec") AS TotalKwhRec
     , SUM("kWh del-rec") AS TotalKwhDel-Rec

  FROM   --(*vendor(PML),product(LogServer) EgyDmd Log@ALI.7600 *)--

  WHERE  (timestamp <= today_12AM()
         AND
        timestamp >= yesterday())

  ORDER BY timestamp DESC
----------


hope this helps a bit
bruintje
0
Aneesh RetnakaranDatabase AdministratorCommented:
SELECT [timestamp]   -- put a square bracket around this timestamp since it is a keyword
     , "kWh del"
     , "kWh rec"
     , "kWh del-rec"

  FROM   --(*vendor(PML),product(LogServer) EgyDmd Log@ALI.7600 *)--

  WHERE  CONVERT(varchar(10),[timestamp]1,120)    = CONVERT(varchar(10),GETDATE()-1,120)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.