Regarding date time issue

See more:

C#3.0

C#

SQL

User will enter datetime in mm/dd/yyyy hh:mm:sec format because in my database i have time format in mm/dd/yyyy and i should also retrieve data from other database which is in dd/mm/yyyy with the same input datetime which is given before by the user. So i tried bellow logic.


DateTime dd1 = dt1;
DateTime dd2 = dt2;
string newdate1 = dd1.ToString("dd/mm/yyyy hh:mm:ss");
string newdate2 = dd2.ToString("dd/mm/yyyy hh:mm:ss");



but in mm it is taking random value i.e if user entered 06(month) but it is taking a random value other than 06 while converting.

i also tried in sql in different formats.

select top 1 receivedtime,stfuelpercent/10,(stfuellevel/100)*2.605 from m2m_raw_fuel where receivedtime between convert(nvarchar(50),'06/16/2013 10:43:00',102) and convert(nvarchar(50),'06/16/2013 14:09:00',102) order by receivedtime desc


the above query is also not converting mm/dd/yyyy to dd/mm/yyyy. so please help me.