this article reprinted to http://blog.sina.com.cn/s/blog_a843a8850101dzqd.html[CPP]View Plaincopy
To set the time display format:
nsstring* timestr = @ "2011-01-26 17:40:50";
NSDateFormatter *formatter = [[[[NSDateFormatter alloc] init]
ConvertExplicitly converts a data type expression to another data type. Because some requirements often use different date formats, the following can be found inFormat the date in SQL Server.
SQL Server supports the data format in the Arabic style
CONVERT (Data_type,expression[,style])CONVERT (varchar (10), field name, conversion format)DescriptionThis style is typically in the time type (Datetime,smalldatetime) and the string type (Nchar,nvarchar,char,varchar)It is only used when converting
Use convert in SQL server2000 to get the datetime data type style (full)Processing of date data formats, two examples:CONVERT (varchar (16), time one, 20) results: 2007-02-01 08:02/* time is generally a field in the GETDATE () function or data table
Processing of date data format:
Result of convert (varchar (16), time 1, 20): 2007-02-01 08: 02
Result of convert (varchar (10), time 1, 23): 2007-02-01
Statement and query result:Select convert (varchar (100), getdate (), 0): 05 16 2006
iOS Standard time and timestamp convert each other(2012-07-18 17:03:34)reproduced
Tags: ios timestamp Standard Time format conversion Talk
Category: iphone development
Set time display format: nsstring*
Processing of date data formats, two examples:CONVERT (varchar (16), time one, 20) results: 2007-02-01 08:02/* time is generally a field in the GETDATE () function or data table */CONVERT (varchar (10), time one, 23) Result: 2007-02-01/*varchar (10)
The time format normally deposited in the database is yyyy-mm-ddhh:mm:ss if you want to convert to yyyy-mm-dd Short date format. You can use the CONVERT function. The following is a declaration of the CONVERT function in SQL Server Help:Using
Convert function [data type conversion]
--------------------------------------------------------------------------------
FunctionReturns the expression converted to the provided data type.
SyntaxConvert (data type, expression [, format-style])
The time in Javascript will inevitably deal with time when programming. For example, to complete a second kill, it involves time access, time synchronization, time difference calculation, and many other details. A simple example of JavsScript. When
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.