CODEWITHSUNDEEP
c#asp.netsql
user3445262
user3445262

Reputation: 25

How to convert datetime from character string

select dbo.CLOI_ClientOrderItems.cl_id, sum(dbo.IN_Invoices.in_total) as Total
from CLOI_ClientOrderItems
inner join IN_Invoices on CLOI_ClientOrderItems.MasterOrderId=IN_Invoices.MasterOrderId
where dbo.IN_Invoices.in_date_issued='2014-01-21 12:30:51.190'
group by cl_id;

Upvotes: 1

Views: 62

Answers (2)

MusicLovingIndianGirl
MusicLovingIndianGirl

Reputation: 5947

Try

select 
    dbo.CLOI_ClientOrderItems.cl_id, 
    sum(dbo.IN_Invoices.in_total) as Total
from 
    CLOI_ClientOrderItems
    inner join IN_Invoices 
on 
    CLOI_ClientOrderItems.MasterOrderId=IN_Invoices.MasterOrderId
where 
    dbo.IN_Invoices.in_date_issued=CONVERT(datetime, '2014-01-21 12:30:51.190', 120)

Upvotes: 3

Vignesh Kumar A
Vignesh Kumar A

Reputation: 28403

Try this

select dbo.CLOI_ClientOrderItems.cl_id, sum(dbo.IN_Invoices.in_total) as Total
from CLOI_ClientOrderItems
inner join IN_Invoices on CLOI_ClientOrderItems.MasterOrderId=IN_Invoices.MasterOrderId
where dbo.IN_Invoices.in_date_issued=CAST('2014-01-21 12:30:51.190' AS Date)
group by cl_id;

Upvotes: 1

Related Questions