关于日期时间问题 [英] Regarding date time issue
问题描述
用户将以mm / dd / yyyy hh:mm:sec格式输入日期时间,因为在我的数据库中我有时间格式,单位为mm / dd / yyyy,我也应该从其他数据库中检索dd / mm / yyyy中的数据具有与用户之前给出的相同的输入日期时间。所以我试着低于逻辑。
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);
但是以毫米为单位它是随机值,即如果用户输入06(月份)但是在转换时它采用的是06以外的随机值。
i也尝试了不同格式的sql。
选择前1个接收时间,stfuelpercent / 10,(stfuellevel / 100)* 2.605来自m2m_raw_fuel,接收时间为转换时间(nvarchar(50),'06/16/2013 10:43:00',102)和转换(nvarchar(50),'06/16/2013 14:09:00',102)按订货时间订购desc
上述查询也没有将mm / dd / yyyy转换为dd / mm / yyyy。所以请帮助我。
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.
推荐答案
请用大写字母写几个月。即
Please write months in capital letter. i.e.
string newdate1 = dd1.ToString("dd/MM/yyyy hh:mm:ss");
string newdate2 = dd2.ToString("dd/MM/yyyy hh:mm:ss");
这篇关于关于日期时间问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!