problemas con campo timestamp

[[Lepe]]

Empezado por Ayuda Delphi

Unit

SysUtils

Category

date/time routines

function TimeStampToDateTime(const TimeStamp: TTimeStamp): TDateTime;

Description

Call TimeStampToDateTime to convert a TTimeStamp value into a TDateTime value. TTimeStamp values represent time as separate date and time values, where the date is the number of calendar days since the start of the current calendar (that is, January 1, 0001 would have a value of 1), and time is the number of milliseconds since midnight. TDateTime values represent time as the number of days (including fractional days) that have elapsed since 12:00 am on December 30, 1899.

Unit

SysUtils

Category

date/time routines

function DateTimeToTimeStamp(DateTime: TDateTime
): TTimeStamp;

Description

Call DateTimeToTimeStamp to convert a TDateTime value into a TTimeStamp value.

Deberías usar TimeStampToDateTime para rescatar valores de la base de datos y mostrarlo en un TdatetimePicker (por ejemplo)

Deberías usar DateTimeToTimeStamp para convertir una fecha y guardarla en la base de datos.

PosData: olvidate de la comilla simple cuando trabajes con TimeStamp.

Un saludo