Calculating Date for ArcSDE gdb - not getting Hours, Minutes, Seconds

SaraShullaw — Mon, 07 May 2012 16:10:04 GMT

Hello,

I'm trying to calculate a date field for a feature class in an ArcSDE gdb using Python. My script successfully calculates the year, month, day but only calcs zeros for hours minutes seconds. Can you help? Here is the relevant portion of my script:

# Import system modules
import arcpy, os, sys
from arcpy import env
import datetime

nowDate = datetime.datetime.now()
dateExp = nowDate.strftime("%Y-%m-%d %H:%M:%S")
arcpy.CalculateField_management("selectLyr", "UpdDate", "date '" + dateExp + "'", "", "")

Re: Calculating Date for ArcSDE gdb - not getting Hours, Minutes, Seconds

DavidWynne — Sat, 11 Dec 2021 06:19:11 GMT

Hi Todd,
You could use the datetime object directly, sort of like below

arcpy.CalculateField_management("selectLyr", "UpdDate", `datetime.datetime.now()`, "PYTHON")

-Dave

Note: I'm using backtick's around the datetime when pushing it into the tool (just stating this in case that isn't obvious)

topic Re: Calculating Date for ArcSDE gdb - not getting Hours, Minutes, Seconds in Python Questions

Calculating Date for ArcSDE gdb - not getting Hours, Minutes, Seconds

Re: Calculating Date for ArcSDE gdb - not getting Hours, Minutes, Seconds