Sql Help

[Sudigali_Sudeer]

I have 2 columns - TimeIn and Time out - It shld display HH:MM:SS AM or( PM) eg: 2:00:17 PM

[argadorn]

em cheyamantavu 

[khabardar]

difference ala chupichala?

[Sudigali_Sudeer]

Query kaavali bhayya  - Currently using this query - CONVERT(VARCHAR(8),TimeIn,108) + ' ' + RIGHT(CONVERT(VARCHAR(30), Timein, 9), 2) AS TimeIn 

Result 24 hr format lo vasthundhi - I need in 12 hrs format 

[rakeshchinna]

SELECT LTRIM(RIGHT(CONVERT(CHAR(20), GETDATE(), 22), 11)) FOR PM 
 

[sarkaar]

Use :

to_char(TimeIn ,'DD-MON-YYYY HH24:MI:SS.FF')

 

for 12 hr s format use:

 

to_char(TimeIn ,'DD-MON-YYYY HH:MI:SS.FF')

[Srimantudu]

5 minutes ago, argadorn said:

em cheyamantavu 

google.com asalu vadatledu ga pilllau

[Sudigali_Sudeer]

4 minutes ago, rakeshchinna said:

SELECT LTRIM(RIGHT(CONVERT(CHAR(20), GETDATE(), 22), 11)) FOR PM 
 

Thanks Bhayya..

[argadorn]

9 minutes ago, Srimantudu said:

google.com asalu vadatledu ga pilllau

yeah..ardam kaledhu emo...

[nenu_devudni]

1 hour ago, sarkaar said:

Use :

to_char(TimeIn ,'DD-MON-YYYY HH24:MI:SS.FF')

 

for 12 hr s format use:

 

to_char(TimeIn ,'DD-MON-YYYY HH:MI:SS.FF')