DATETIME won't accept this particular format because only ":", not ".", is allowed as a delimiter in a time.
I think that some string manipulation to replace "." by ":" will be needed. On Mon, Feb 25, 2019 at 06:55:42PM +0200, Oren Ish-Shalom wrote: > When you read from a *.csv file like below, you can specify the attributes. > Like this: > > GET DATA > /TYPE=TXT > /FILE='input.csv' > /FIRSTCASE=2 > /VARIABLES= > A F8 > B F8 > . > > What did you specify as the type of the date column? > > > On Mon, Feb 25, 2019 at 6:47 PM Matteo Ga <matteo.galv...@mail.com> wrote: > > > Hi again, > > I have imported a dataset from CVS and I have a field that schould be a > > date but It actually is a string. > > > > Ex: > > 31/12/2018 24.59.30 > > > > How can I get a variable in DATETIME format? > > > > thank you > > > > MG > > _______________________________________________ > > Pspp-users mailing list > > Pspp-users@gnu.org > > https://lists.gnu.org/mailman/listinfo/pspp-users > > > _______________________________________________ > Pspp-users mailing list > Pspp-users@gnu.org > https://lists.gnu.org/mailman/listinfo/pspp-users _______________________________________________ Pspp-users mailing list Pspp-users@gnu.org https://lists.gnu.org/mailman/listinfo/pspp-users
