首页 \ 问答 \ SQL CONVERT函数在SQL Server中工作但不在应用程序中(SQL CONVERT function working in SQL Server but not in application)

SQL CONVERT函数在SQL Server中工作但不在应用程序中(SQL CONVERT function working in SQL Server but not in application)

我有以下代码:

…
var sqlCom =
            new SqlCommand("SELECT TOP 1 …,CONVERT(date,dtetme) AS dtetme… FROM class c WHERE id=@id;", sqlCon);
…

        try
        {
            while (sdr.Read())
                for (int i = 0; i < 11; i++)
                    rslt[i] = sdr.GetValue(i).ToString();
        }

dtetme在我的SQL Server 2012数据库中的类型为smalldatetime 。 我只想从中提取日期,这就是我使用CONVERT(date,dtetme)函数的原因。 在SQL服务器上运行时,它只返回预期的日期,但在应用程序中,它将返回附加的默认时间戳。 我不想这样: 9/19/2013 12:00:00 AM

知道为什么它在SQL Server中工作而不在我的应用程序中吗?


I have a following code:

…
var sqlCom =
            new SqlCommand("SELECT TOP 1 …,CONVERT(date,dtetme) AS dtetme… FROM class c WHERE id=@id;", sqlCon);
…

        try
        {
            while (sdr.Read())
                for (int i = 0; i < 11; i++)
                    rslt[i] = sdr.GetValue(i).ToString();
        }

The column dtetme is of type smalldatetime in my SQL Server 2012 database. I only want to extract date from it so that’s why I am using CONVERT(date,dtetme) function. When run on SQL server, it returns only the date as expected, but in the application it is returning it with a default timestamp attached. I don’t want like this: 9/19/2013 12:00:00 AM.

Any idea why it is working in SQL Server and not in my application?


原文:https://stackoverflow.com/questions/18992113
更新时间:2020-03-22 23:56

最满意答案

日期是日期是日期。 不是字符串。 您应该将其作为日期阅读,然后根据您的选择进行格式化。 对数据库来说,日期只是一个数字 - 它没有格式概念。 所以:

var when = sdr.GetDateTime(i);
// now format when

A date is a date is a date. Not a string. You should read it as a date, and then format it as you choose afterwards. To the database, a date is just a number - it has no notion of format. So:

var when = sdr.GetDateTime(i);
// now format when
2013-09-24

相关文章

更多

最新问答

更多
  • 如何避免MDIParent表单调整大小(How do I avoid MDIParent form from resizing)
  • Angular自定义指令调用另一个自定义指令(Angular custom directive calling another custom directive)
  • 如何通过参数将文本解析并附加到SQL Server 2005中的存储过程(How to Parse and Append text to a stored procedure in SQL Server 2005 via a parameter)
  • OpenCV中心Homography(OpenCV Center Homography)
  • 如何在linux shell脚本中计算日期-N?(How to calculate date -N in linux shell scripting?)
  • 如何使用Devise创建用户配置文件?(How Do I Create a User Profile With Devise?)
  • 清理模式以管理树上的多步异步过程(Clean pattern to manage multi-step async processes on a tree)
  • 场景的角色(Role of the Scene)
  • 组件中的Angular 2组件[重复](Angular 2 Component In Component [duplicate])
  • jsPlumb draggable element javascript函数(jsPlumb draggable element javascript function)
  • MVC4:ViewModel(带有radiobuttonlist)在HttpPost之后为空(MVC4: ViewModel (with radiobuttonlist) is empty after HttpPost)
  • 如何在同一帐户上设置“Dev repo”(在prod和团队之间)(How to set up a “Dev repo” (between the prod and the team) on the same account)
  • 如何在tcl中将eth0配置为发送方udp端口(how to configure eth0 as a sender udp port in tcl)
  • 如何使用预定义文本替换来自数据库的部分结果(How do I replace part of result coming from Database with predefined text)
  • Selenium Java注入了新的Javascript函数(Selenium Java inject new Javascript function)
  • 使用.on的多个下拉菜单选择文本仅适用于第一个下拉列表(Multiple Dropdowns Menu Selection text using .on works only on first dropdown)
  • 快速将黄土曲线添加到大型数据集图中的方法(Quick way to add loess curve to large data set graph)
  • FilteringSelect in mvc(FilteringSelect in mvc)
  • 在Delphi XE2中开发Mac或iOS应用程序需要哪些硬件/软件?(What hardware/software is necessary to develop Mac or iOS apps in Delphi XE2?)
  • 在原型的构造函数中初始化属性时获取“未定义”(Getting 'undefined' when a property is initialized in the constructor of a prototype)
  • 通过越狱加载的应用程序的Documents文件夹位置(Location of Documents folder for an app loaded via jailbreak)
  • 在OpenGL中使用可编程和固定管道功能(Using both programmable and fixed pipeline functionality in OpenGL)
  • 将任何用户输入重定向到单独的底层程序(redirect any user input to a separate underlying program)
  • 编辑文本不能正常工作android(Edit texts not working properly android)
  • “user_denied”Facebook应用页面上的Facebook用户区域设置(Facebook user locale on “user_denied” facebook app page)
  • 在大图像中找到小的部分透明图像的坐标(find coordinates of small partially-transparent image within a large image)
  • 我如何在cakephp 3.1中获得完整的相对路径?(How i can get full relative path of image in cakephp 3.1?)
  • 如何保存拖动标记的新本地化?(How to save new localization of dragged marker?)
  • MySQL UPDATE vs INSERT和DELETE(MySQL UPDATE vs INSERT and DELETE)
  • 在执行查询之前,在SQLAlchemy模型中将datetime转换为unix时间戳?(Convert datetime to unix timestamp in SQLAlchemy model before executing query?)