如何选择CAST（作为日期时间编号） [英] How select CAST( codate as datetime)

问题描述

如何选择CAST（Codate作为日期时间）。



我尝试过：



删除我的问题

How select CAST( Codate as datetime) .

What I have tried:

delete my question

推荐答案

根据SQL服务器日期格式转换可能失败或可能成功。



尝试使用 SET DATEFORMAT [ ^ ]命令 SELECT 声明。

Depending on SQL server date format conversion may failed or may succeed.

Try to use SET DATEFORMAT[^] command before SELECT statement.

SET DATEFORMAT ymd;
SELECT CONVERT(DATETIME, VarcharField) AS MyDateTime

所以不要将日期存储为字符串：它总是会出现问题。

以正确列数据类型存储数据：INT中的整数，DATETIME中的日期。这样你就知道你的数据库中的数据总是正确的 - 因为如果不是这样的话，它就不会存在。



将所有内容存储在NVARCHAR列中似乎很容易，但是当你开始看到它时会给你带来很大的问题。



在这个早期阶段咬紧牙关并纠正你的整个数据库 - 因为如果你离开它太长时间你将拥有大量的代码/数据，你可以做任何事情！

So don't store dates as strings: it always gives problems.
Store data in "proper" column datatypes: integers in INT, Dates in DATETIME. That way you know the data in your db is always correct - because if it wasn't, it wouldn't be there.

Storing everything in NVARCHAR columns seems easy, but it gives huge problems down the line as you are starting to see.

Bite the bullet and correct your whole DB now, at this early stage - becasue if you leave it too long you will have a large body of code / data which you can;t do anything with!

你好朋友

As（OriginalGriff）说...这是同样的问题我是巧合它应该首先检查你是否改变默认数据库整理如果你改变它然后

你必须看到我的解决方案：



Cast（[QTE_IN_STOCK] AS Varchar（50））COLLATE DATABASE_DEFAULT

Hello Friend
As (OriginalGriff) Says...This Is The Same Problem I Coincidence It Should First Check If You Are Change The Default Database Collation If You Change It Then
You Must See My Solution :

Cast([QTE_IN_STOCK] AS Varchar(50))COLLATE DATABASE_DEFAULT

这篇关于如何选择CAST（作为日期时间编号）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！