Geek asks and answers

Date format in dd / MM / yyyy hh: mm: ss format

I need to convert datetime from 2012-07-29 10:53:33.010to 29/07/2012 10:53:33.

I tried to use

select CONVERT(varchar(20), GETDATE(), 131)

but its display date according to the Hijri calendar

11/09/1433 10:53:33:

Please, help?

+5
source share
7 answers

This can be done as follows:

select CONVERT(VARCHAR(10), GETDATE(), 103) + ' '  + convert(VARCHAR(8), GETDATE(), 14)

Hope this helps

+16
source

You can combine two formats:

3   dd/mm/yy   (British/French)
8   hh:mm:ss

according to CONVERT()function and using operator +:

SELECT CONVERT(varchar(10),GETDATE(),3) + ' ' + CONVERT(varchar(10),GETDATE(),8)
+3
source 
CREATE FUNCTION DBO.ConvertDateToVarchar
(
@DATE DATETIME
)

RETURNS VARCHAR(24) 
BEGIN
RETURN (SELECT CONVERT(VARCHAR(19),@DATE, 121))
END
+1
SELECT FORMAT(your_column_name,'dd/MM/yyyy hh:mm:ss') FROM your_table_name

-

SELECT FORMAT(GETDATE(),'dd/MM/yyyy hh:mm:ss')
+1

varchar, , .

RIGHT('0' + LTRIM(DAY(d)), 2) + '/'
+ RIGHT('0' + LTRIM(MONTH(d)), 2) + '/'
+ LTRIM(YEAR(d)) + ' '
+ RIGHT('0' + LTRIM(DATEPART(HOUR, d)), 2) + ':'
+ RIGHT('0' + LTRIM(DATEPART(MINUTE, d)), 2) + ':'
+ RIGHT('0' + LTRIM(DATEPART(SECOND, d)), 2)

d - datetime.

0
SELECT CONVERT(CHAR(10),GETDATE(),103) + ' ' + RIGHT(CONVERT(CHAR(26),GETDATE(),109),14)
0

CAST CONVERT - MSDN ... №. 121 (ODBC ( )), , :

SELECT CONVERT(VARCHAR(30), GETDATE(), 121)

:

2012-04-14 21:44:03.793

: - , - (: '4/14/2012 2:44:01 PM' - -!) ......

, , DATETIME THEN, !

:

SELECT CONVERT(VARCHAR(30), CAST('4/14/2012 2:44:01 PM' AS DATETIME), 121)

:

2012-04-14 14:44:01.000

, , ...

0

More articles:


All Articles