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.