How to get DATE from DATETIME Column in SQL?

SqlSql ServerDateDatetime

Sql Problem Overview

I have 3 columns in Table TransactionMaster in sql server

  1. transaction_amount

  2. Card_No

  3. transaction_date-- datetime datatype

So, I want to fetch SUM of transaction_amount where Card_No=' 123' and transaction_date= todays date.<----- excluding time IN SQL

Sql Solutions

Solution 1 - Sql

Simply cast your timestamp AS DATE, like this:

SELECT CAST(tstamp AS DATE)

SQLFiddle Demo

In other words, your statement would look like this:

SELECT SUM(transaction_amount)
FROM mytable
WHERE Card_No='123'
  AND CAST(transaction_date AS DATE) = target_date

What is nice about CAST is that it works exactly the same on most SQL engines (SQL Server, PostgreSQL, MySQL), and is much easier to remember how to use it. Methods using CONVERT() or TO_DATE() are specific to each SQL engine and make your code non-portable.

Solution 2 - Sql

You can use

select * 
from transaction 
where (Card_No='123') and (transaction_date = convert(varchar(10),getdate(),101))

Solution 3 - Sql

use the following

select sum(transaction_amount) from TransactionMaste
where Card_No = '123' and transaction_date = CONVERT(VARCHAR(10),GETDATE(),111)

or the following

select sum(transaction_amount) from TransactionMaste
where Card_No = '123' and transaction_date = CONVERT(VARCHAR(10), GETDATE(), 120)

Solution 4 - Sql

Use Getdate()

 select sum(transaction_amount) from TransactionMaster
 where Card_No=' 123' and transaction_date =convert(varchar(10), getdate(), 102)

Solution 5 - Sql

Try this:

SELECT SUM(transaction_amount) FROM TransactionMaster WHERE Card_No ='123' AND CONVERT(VARCHAR(10),GETDATE(),111)

The GETDATE() function returns the current date and time from the SQL Server.

Categories
Recommended Sql Solutions
Recommended Sql Server Solutions
Recommended Date Solutions
Recommended Datetime Solutions

Previous Solution:

Do I not understand the flex-grow property?

CssFlexboxFlex Grow

Next Solution:

How to use font-family lato?

CssFont FamilyGoogle Font-Api

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
Questionuser3239820View Question on Stackoverflow
Solution 1 - SqlmvpView Answer on Stackoverflow
Solution 2 - SqlMilan RavalView Answer on Stackoverflow
Solution 3 - SqlDeveloperzzzView Answer on Stackoverflow
Solution 4 - SqlNagaraj SView Answer on Stackoverflow
Solution 5 - SqlAjayView Answer on Stackoverflow