Click here to Skip to main content
13,091,894 members (63,310 online)
Click here to Skip to main content

Tagged as

Stats

1K views
Posted 22 Jan 2013

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

, 22 Jan 2013
Hello Friendswith 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 belowamountpaid date ...

Revisions


  

Compare Revision Minor Date Status Editor
3 - publicly available No 22-Jan-13 2:35 Available Orcun Iyigun
added code tags
1 No 22-Jan-13 1:16 Available Rohit Sharma706

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Rohit Sharma706
Software Developer (Junior)
India India
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Group type: Social Group (No members)



You may also be interested in...

Pro
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.170813.1 | Last Updated 22 Jan 2013
Article Copyright 2013 by Rohit Sharma706
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid