[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