English 中文(简体)
• 将日值改为小时
原标题:how to convert the datetime value to hour

我的时日价值

  1. 2010-04-07 09:00:00.000

  2. 2010-04-07 14:30:000

如何将14:30改为2:30 pm

最佳回答
SELECT RIGHT(CONVERT(varchar(7), Myvalue, 100), 7)

在客户法典中这样做甚至更好。

问题回答

如果是这样的话,你是否希望这样做。

select date_format(date, "%Y-%m-%d %r") from table_name

另见

* E/CN.6/2009/1。 方法

<>strong>gbn , 难道你指的是?





相关问题
How to write this T-SQL WHERE condition?

I ve got two tables: TableA Col1 Col2 TableB Col3 Col4 I want to join them together: SELECT * from TableA join TableB ON (...) Now, in place of ... I need to write an expression ...

Customer and Order Sql Statement

TSQL query to select all records from Customer that has an Order and also select all records from customer that does not have an Order. The table Customer contains a primary key of CustomerID. The ...

Recommended way of querying multiple Versioned tables

Have a win 2003 box with MSSQL 2005 running on it. There is a database which is populated every morning with new/modified SalesOrder made the previous day. The database has several tables: SalesOrder, ...

update duplicate record

I have a table with the following fields Id Name IsPublic i need to write a sql query that updates IsPublic to false where name has a duplicate. Only one of the duplicates should have IsPublic = ...

Define variable to use with IN operator (T-SQL)

I have a Transact-SQL query that uses the IN operator. Something like this: select * from myTable where myColumn in (1,2,3,4) Is there a way to define a variable to hold the entire list "(1,2,3,4)"? ...

Selecting records during recursive stored procedure

I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...

热门标签