convert minute second and millisecon

Question

0.00/5 (No votes)

See more:

hi friend
i want to convert to date time to minute second and millisecond and my problem is i want to convert to date time like

2013-06-05 15:45:40.000

and my query is
SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond
and output is
15:45:40

but i want to 154540 how to it possible plz help me

Posted 5-Jun-13 0:17am

Rashmikants Monpara

Updated 5-Jun-13 0:21am

v2

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zafar Sultan · Accepted Answer · 2013-06-05T00:24:00

Solution 1

SQL

DECLARE @SAMPLEDATE VARCHAR(10)
DECLARE @FORMATTEDTIME VARCHAR(10)

SET @SAMPLEDATE = CONVERT(VARCHAR(8),GETDATE(),108)
SET @FORMATTEDTIME =   REPLACE(@SAMPLEDATE ,':','');

PRINT @FORMATTEDTIME

Posted 5-Jun-13 0:24am

Zafar Sultan

Comments

Maciej Los 5-Jun-13 6:28am

Good work ;)
+5

Zafar Sultan 5-Jun-13 6:33am

Thanks.

[no name] 5-Jun-13 6:40am

Awesome :)

Zafar Sultan 5-Jun-13 7:03am

Thank you.

Maciej Los · Accepted Answer · 2013-06-05T00:26:00

Solution 2

Use this:

SQL

SELECT REPLACE(CONVERT(VARCHAR(8),GETDATE(),108),':','') AS HMS

More about: REPLACE (T-SQL)[^]

Posted 5-Jun-13 0:26am

Maciej Los

SagarRS · Accepted Answer · 2013-06-05T00:28:00

Solution 3

Use Replace Function like below

SQL

SELECT replace(CONVERT(VARCHAR(8),GETDATE(),108),':','') AS HourMinuteSecond

Posted 5-Jun-13 0:28am

SagarRS

convert minute second and millisecon

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

convert minute second and millisecon

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us