pspp-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: string to date (actually datetime)


From: Ben Pfaff
Subject: Re: string to date (actually datetime)
Date: Mon, 25 Feb 2019 09:14:56 -0800
User-agent: Mutt/1.10.1 (2018-07-13)

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 <address@hidden> 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
> > address@hidden
> > https://lists.gnu.org/mailman/listinfo/pspp-users
> >

> _______________________________________________
> Pspp-users mailing list
> address@hidden
> https://lists.gnu.org/mailman/listinfo/pspp-users




reply via email to

[Prev in Thread] Current Thread [Next in Thread]