Displaying 2 results from an estimated 2 matches for "fecha_operacion".
2006 Jul 14
1
error with Dates in SQL Server
...at problem.
-- fxn
DBI::DatabaseError: 22008 (242) [Microsoft][ODBC
SQL Server Driver][SQL Server]La conversi?n del tipo de datos char a
datetime p
odujo un valor datetime fuera de intervalo.: INSERT INTO movimientos
([carpeta]
[otras_caracteristicas], [fecha_valor], [importe_operacion],
[fecha_operacion]
[oficina], [referencia_1], [remite], [referencia_2], [divisa],
[concepto], [cr
ado_en], [cuenta], [concepto_especifico], [entidad], [saldo],
[estado]) VALUES(
53386185'', ''C00607-060714-105544-0095'', ''2006-07-14'', 235500,
''2006-07-14'...
2006 Jul 17
18
Inserting datetime value into SQL Server
I have a SQL Server column named StartTime of (SQL Server) type datetime
If I attempt to set the attribute using
public
def StartTime=(time)
write_attribute(:StartTime, "{ts ''1899-12-30
#{time.hour}:#{time.min}:#{time.sec}''}")
end
it''s inserting a NULL value.
Anyone else able to successfully insert a date time value into a SQL
Server table using