Re: string to date (actually datetime)

2019-02-25 Thread Ben Pfaff
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, y

Re: string to date (actually datetime)

2019-02-25 Thread Oren Ish-Shalom
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 wrote: > Hi again, > I have imported