Click here to Skip to main content
15,867,453 members
Home / Discussions / Database
   

Database

 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp210-Jun-21 1:25
SeeSharp210-Jun-21 1:25 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mycroft Holmes10-Jun-21 12:09
professionalMycroft Holmes10-Jun-21 12:09 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mohammad Salmani10-Jun-21 21:53
Mohammad Salmani10-Jun-21 21:53 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp211-Jun-21 1:20
SeeSharp211-Jun-21 1:20 
QuestionLoad JSON file from network location Pin
Member 144746073-Jun-21 7:36
Member 144746073-Jun-21 7:36 
AnswerRe: Load JSON file from network location Pin
Member 144746073-Jun-21 8:42
Member 144746073-Jun-21 8:42 
AnswerRe: Load JSON file from network location Pin
Mycroft Holmes3-Jun-21 12:15
professionalMycroft Holmes3-Jun-21 12:15 
QuestionSQL Server 2010, smalldatetime insert Pin
jkirkerx1-Jun-21 14:52
professionaljkirkerx1-Jun-21 14:52 
I'll swear I have this right
The field is smalldatetime. I'm just picking up the record and inserting it.

On select, I used
CONVERT(varchar(33), ADD_DATE, 121) AS ADD_DATE,
Oninsert, the sql looks like this
'1900-01-01 00:00:00.000'

I read up on sql date times and the different formats. If I pick it raw, and try o insert it, I get an object error.
In SQL Manager, I get
Conversion failed when converting character string to smalldatetime data type.
Warning: sqlsrv_fetch_array() expects parameter 1 to be resource, bool given in C:\App\Dev\PCAD\repository\projectOrder.repository.php on line 1182
Array ( [0] => Array ( [0] => 22007 [SQLSTATE] => 22007 [1] => 295 [code] => 295 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting character string to smalldatetime data type. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting character string to smalldatetime data type. ) ) addProjectCost 1749 INSERT INTO [proj_cost] ( Proj_ID, Proj_Stage, Vers_ID, Task_ID, Task_Oper, Task_Class, Vend_ID, CO_Proj_Type, CO_Type, CO_Type_D, CO_Value, Cost, ADD_NO, ADD_DATE, ADD_CODE, Pref_Vendor, User_Last_Upd, Delete_Flag ) VALUES ( '2549', 'engineering', '0', 'TK_AT_001', '85', 'OP', '', '39', 'PoolSpa', 'REF_AT_002', '', '25', '175', '0', '1900-01-01 00:00:00.000', '', 'jimk', 0 ) - 1
If it ain't broke don't fix it
Discover my world at jkirkerx.com

AnswerRe: SQL Server 2010, smalldatetime insert Pin
Mycroft Holmes1-Jun-21 21:31
professionalMycroft Holmes1-Jun-21 21:31 
AnswerRe: SQL Server 2010, smalldatetime insert Pin
Victor Nijegorodov1-Jun-21 21:49
Victor Nijegorodov1-Jun-21 21:49 
AnswerRe: SQL Server 2010, smalldatetime insert Pin
jkirkerx2-Jun-21 8:47
professionaljkirkerx2-Jun-21 8:47 
QuestionGet columns name Pin
_Flaviu27-May-21 23:55
_Flaviu27-May-21 23:55 
AnswerRe: Get columns name Pin
Victor Nijegorodov28-May-21 0:22
Victor Nijegorodov28-May-21 0:22 
GeneralRe: Get columns name Pin
_Flaviu3-Jun-21 5:57
_Flaviu3-Jun-21 5:57 
GeneralRe: Get columns name Pin
Victor Nijegorodov3-Jun-21 20:13
Victor Nijegorodov3-Jun-21 20:13 
GeneralRe: Get columns name Pin
_Flaviu3-Jun-21 20:37
_Flaviu3-Jun-21 20:37 
GeneralRe: Get columns name Pin
Victor Nijegorodov3-Jun-21 21:48
Victor Nijegorodov3-Jun-21 21:48 
GeneralRe: Get columns name Pin
_Flaviu3-Jun-21 23:33
_Flaviu3-Jun-21 23:33 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 0:55
Victor Nijegorodov4-Jun-21 0:55 
AnswerRe: Get columns name Pin
Gerry Schmitz4-Jun-21 7:02
mveGerry Schmitz4-Jun-21 7:02 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 7:21
Victor Nijegorodov4-Jun-21 7:21 
GeneralRe: Get columns name Pin
Gerry Schmitz4-Jun-21 7:54
mveGerry Schmitz4-Jun-21 7:54 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 8:02
Victor Nijegorodov4-Jun-21 8:02 
GeneralRe: Get columns name Pin
Gerry Schmitz4-Jun-21 9:01
mveGerry Schmitz4-Jun-21 9:01 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 9:47
Victor Nijegorodov4-Jun-21 9:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.