Click here to Skip to main content
15,886,199 members

How to grt DateFormate (dd/MM/yyyy) when joining two tables

Revision 1
Hello Friends

with the help of inner join,i joined two table like that

select SR.amountpaid,SR.date,S.name from SupplierRecord as SR inner join Supplier as S on SR.Supplierid=S.Supplierid where Purchaseid ='0'

in this joining i get a date with time like below

amountpaid date name
1000 2013-01-21 12:30:18.000 Vishal
2000 2013-01-22 10:29:41.000 A Mandlekar

but i want a only date (ie.2013-01-21 ) will be come not datewithtime (2013-01-21 12:30:18.000).

so can you please help me.

thnx in advance.
Posted 22-Jan-13 1:16am by Rohit Sharma706.
Tags: