topic Re: Parsing serial date field in Geoprocessing Questions

Parsing serial date field

GordDeVillers — Wed, 02 Jan 2013 13:17:19 GMT

Hello,

I have imported a shapefile that contains a serial date number that looks like this: 41256.260799 . I would like to create a new field that shows only the hour and second like this 06:33 . I've tried the available vb and python date functions, but nothing seems to work. Would I make my new field type text? Any help appreciated.

Gord

Re: Parsing serial date field

JakeSkinner — Sat, 11 Dec 2021 17:04:21 GMT

Hi Gord,

You could use the following python function within the field calculator:

def date(field):
  seconds = (field - 25569) * 86400.0
  time = str(datetime.timedelta(seconds=seconds))
  return time.split(",")[1].split(".")[0]

Here is a screen shot.

[ATTACH=CONFIG]20365[/ATTACH]