Click here to Skip to main content
15,917,928 members

Comments by Danuuu (Top 26 by date)

Danuuu 19-Feb-17 9:07am View    
am not getting how to do?And the example is for Current DateTime and i need to store specific time
Danuuu 19-Feb-17 6:48am View    
Thank you but example is of DateTime and I need to store only TIME how to convert only Time to mysqltime
Danuuu 19-Feb-17 2:35am View    
Okay i will change table name but I haven't got any errors but time coloumn values are 00:00:00
Danuuu 19-Feb-17 2:13am View    
Datatype is Time.And Table name is user
Danuuu 13-Jun-14 2:21am View    
SELECT CASE
WHEN (SELECT COUNT(*) FROM dbo.tempDeviceLogs
WHERE CONVERT(VARCHAR,tempDeviceLogs.logDateTime,101) = CONVERT(VARCHAR,GETDATE() - 31 ,101)
AND Device_Person_id = personal_id) > 0 THEN 'P' ELSE 'A' END as Emp_Status FROM Emp_setting

this code is executing showing only one column i.e emp_status
how to add device_person_id,personal_id,department,designation columns to this code only