MS SQL Server Date Time Column Misinterpretation In Data Editor

[expired user #9586]'s profile image [expired user #9586] posted 8 years ago in General Permalink

expectation

really

Do any plugin dll is necessary?

jfalch's profile image jfalch posted 8 years ago Permalink

what is Entrada_Turno definition line in CREATE CODE tab ?

[expired user #9586]'s profile image [expired user #9586] posted 8 years ago Permalink

what is Entrada_Turno definition line in CREATE CODE tab ?

thanks for replying

other example:

[expired user #9586]'s profile image [expired user #9586] posted 8 years ago Permalink

what is Entrada_Turno definition line in CREATE CODE tab ?

thanks for replying

other example:

jfalch's profile image jfalch posted 8 years ago Permalink

ok, it MSSQL. That's a case for Anse (the Author) then, to activate the appropriate input editors for types SMALLDATETIME and whatever type mappings is (should probably be treated like mysql ENUM). Please do post another screenshot with CREATE CODE for the field mappings; that will increase the probability that the will be able to do something about your problem. Please also post the result of SELECT @@version , since the capabilities of different versions of MSSQL server differ considerably.

[expired user #9586]'s profile image [expired user #9586] posted 8 years ago Permalink

ok, it MSSQL. That's a case for Anse (the Author) then, to activate the appropriate input editors for types SMALLDATETIME and whatever type mappings is (should probably be treated like mysql ENUM). Please do post another screenshot with CREATE CODE for the field mappings; that will increase the probability that the will be able to do something about your problem. Please also post the result of SELECT @@version , since the capabilities of different versions of MSSQL server differ considerably.

CREATE TABLE "SIAF_HORARIOS_EMPLEADOS_DIAS" (
"Conse" INT NOT NULL,
"Fecha" DATE NULL DEFAULT NULL,
"Codigo_Horario" NVARCHAR(20) NULL DEFAULT NULL,
"Dia" NVARCHAR(5) NULL DEFAULT NULL,
"Convencion" NVARCHAR(2) NULL DEFAULT NULL,
"Cedula" NVARCHAR(11) NULL DEFAULT NULL,
"Entrada_Turno" SMALLDATETIME NULL DEFAULT NULL,
"Entrada_Descanso" SMALLDATETIME NULL DEFAULT NULL,
"Salida_Descanso" SMALLDATETIME NULL DEFAULT NULL,
"Salida_Turno" SMALLDATETIME NULL DEFAULT NULL,
"Total_Horas_Turno_Dia" NUMERIC(18,7) NULL DEFAULT NULL,
"Total_Horas_Trabajadas" NUMERIC(18,7) NULL DEFAULT NULL,
"Horas_Extras" NUMERIC(18,7) NULL DEFAULT '0',
"Horas_Perdidas" NUMERIC(18,7) NULL DEFAULT '0',
"Horas_Compensadas" NUMERIC(18,7) NULL DEFAULT '0',
"Codigo_Punto" NVARCHAR(20) NULL DEFAULT NULL,
"Codigo_Permiso" NVARCHAR(20) NULL DEFAULT NULL,
PRIMARY KEY ("Conse")
)
;

result of SELECT @@version

Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
Feb 10 2012 19:39:15 
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)
jfalch's profile image jfalch posted 8 years ago Permalink

thank you. However, I meant the CREATE CODE hat shows the field "mappings" (in your first screenshot). Or was this just an example and your main problem is with SMALLDATETIME fields ? ..also I notice that SMALLDATETIME is not highlighted in the above screenshot (grey, not green), so possibly it is not yet recognized as a valid datatype by heidisql at all.

[expired user #9586]'s profile image [expired user #9586] posted 8 years ago Permalink

thank you. However, I meant the CREATE CODE hat shows the field "mappings" (in your first screenshot). Or was this just an example and your main problem is with SMALLDATETIME fields ? ..also I notice that SMALLDATETIME is not highlighted in the above screenshot (grey, not green), so possibly it is not yet recognized as a valid datatype by heidisql at all.

thanks

problem is not only SMALLDATETIME fields :

(DATETIME datatype)

:

:

===================================================================================

===================================================================================

I'm sorry, I could not find the option mentioned CREATE CODE hat

[expired user #9586]'s profile image [expired user #9586] posted 8 years ago Permalink

result when try edit cell value:

Please login to leave a reply, or register at first.