如何将db2日期字符串转换为sql字符串。(SQL自动转换为datetime) [英] how to convert db2 date string to sql string.( SQL automatically converting to datetime)
问题描述
嗨朋友们,
我需要从DB2获取一些数据并粘贴在SQL中。我能够这样做,但日期格式有些问题。
DB2中的日期格式类似于 2003-09-23 12:32:09.095499
但是当我插入sql时它变成 9/23/2003 12:32:09 PM
实际上是我的DB2字段是字符串而不是日期。但是sql将它转换为日期
我在数据集和数据表的帮助下从DB2中获取数据。在数据集本身发生了日期转换。
如何解决这个问题
我的SQL quey用于提供数据来自DB2
Hi Friends,
I need to fetech some datafrom DB2 and paste in SQL. I am able to do that but some problem in date format.
Date format in DB2 is like 2003-09-23 12:32:09.095499
but when i insert into sql its became 9/23/2003 12:32:09 PM
actually my DB2 field is a string not a date. but sql converts it into date
i am feteching data from DB2 with help of dataset and datatable. In the dataset itself dateconversion occur.
How can i solve this
My SQL quey for feteching data from DB2
SELECT KEY_TMS, CAT_TRDCTL, DT2_BILL, CAT_BILL, DT2_FROM, KEY_ACCT, DT2_ME, AMT_MKTVAL FROM TBL_BILL
这就是我将值传递给sql的方法
this is how i am passing value to sql
cmd.Parameters.Add("@KEY_TMS", SqlDbType.VarChar).Value =dt.Rows[i]["KEY_TMS"].ToString();
已编辑***
根据建议我制作日期格式
但是毫秒部分没有按预期工作
Edited***
As per suggestion i made date formating
but millisecond portion is not working as expected
keytms_date = Convert.ToDateTime(dt.Rows[i]["KEY_TMS"].ToString());
cmd.Parameters.Add("@KEY_TMS", SqlDbType.VarChar).Value = keytms_date.ToString("yyyy-MM-dd hh:mm:ss.ffffff");
它显示000000 insted 095499
如何解决这个问题
its showing 000000 insted of 095499
how can i solve this issue
推荐答案
要修复它,请更改.ToString()并格式化字符串。
查看自定义日期和时间格式字符串
I假设您已在SQL数据库中将此字段声明为varchar而不是datetime。
To fix it change .ToString() and format the string.
Take a look at ustom Date and Time Format Strings
I suppose you have declared this field as varchar instead of datetime in SQL database.
这篇关于如何将db2日期字符串转换为sql字符串。(SQL自动转换为datetime)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!