I have a query: I have a table in SQLite with this structure
CREATE TABLE [Agenda] ( [Itinerario] VARCHAR(50) NULL, [Creado] TIMESTAMP NULL, [Fecha] TIMESTAMP NULL )
And I'm trying to enter rows with the following SQL statement:
INSERT INTO Agenda VALUES ('Ir de Compras','23-08-2016 12:00','24-08-2016 18:00');
But the dates are entered incorrectly.
What should I be doing wrong?
PS: I'm testing these questions from the sqliteadmin since my project is in .NET but it does not take dates well from there either.