STRING to DATE

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

STRING to DATE

drfg2008

How to convert the python timestamp from STRING to DATE format in SPSS?

Example: "25 Apr 2013 14:50:07"

Could not find a solution with ALTER TYPE
(i.e.: ALTER TYPE timestamp(date11). produces blanks).



++++++++++++

25 Apr 2013 14:50:07
25 Apr 2013 14:50:07
25 Apr 2013 14:49:42
25 Apr 2013 14:49:42
25 Apr 2013 14:50:07
25 Apr 2013 14:50:09
25 Apr 2013 14:49:58
25 Apr 2013 14:50:05
25 Apr 2013 14:50:05
25 Apr 2013 14:50:06
25 Apr 2013 14:49:57
25 Apr 2013 14:50:02
25 Apr 2013 14:49:25
25 Apr 2013 14:49:17
25 Apr 2013 14:49:47
25 Apr 2013 14:50:01
25 Apr 2013 14:49:56
25 Apr 2013 14:50:08
25 Apr 2013 14:50:06
25 Apr 2013 14:50:06
25 Apr 2013 14:49:53

Dr. Frank Gaeth

Reply | Threaded
Open this post in threaded view
|

Re: STRING to DATE

David Marso
Administrator
Well Frank,
date11 would not apply here.
Try DATETIME
David

drfg2008 wrote
How to convert the python timestamp from STRING to DATE format in SPSS?

Example: "25 Apr 2013 14:50:07"

Could not find a solution with ALTER TYPE
(i.e.: ALTER TYPE timestamp(date11). produces blanks).



++++++++++++

25 Apr 2013 14:50:07
25 Apr 2013 14:50:07
25 Apr 2013 14:49:42
25 Apr 2013 14:49:42
25 Apr 2013 14:50:07
25 Apr 2013 14:50:09
25 Apr 2013 14:49:58
25 Apr 2013 14:50:05
25 Apr 2013 14:50:05
25 Apr 2013 14:50:06
25 Apr 2013 14:49:57
25 Apr 2013 14:50:02
25 Apr 2013 14:49:25
25 Apr 2013 14:49:17
25 Apr 2013 14:49:47
25 Apr 2013 14:50:01
25 Apr 2013 14:49:56
25 Apr 2013 14:50:08
25 Apr 2013 14:50:06
25 Apr 2013 14:50:06
25 Apr 2013 14:49:53
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Automatic reply: STRING to DATE

Paige Ransford

I will be out of the office from April 26, 2013 through April 29, 2013. If you need immediate assistance please call 617-287-5541.

Paige Ransford
Senior Research Associate
The Center for Women in Politics & Public Policy
UMass Boston