Posts

Showing posts from April 21, 2019

North Bethesda, Maryland

Image
Census-designated place in Maryland, United States North Bethesda, Maryland Census-designated place North Bethesda Market East Tower Location of North Bethesda, Maryland Boundaries of the North Bethesda CDP, as of 2003 Coordinates: 39°2′12″N 77°7′13″W  /  39.03667°N 77.12028°W  / 39.03667; -77.12028 Coordinates: 39°2′12″N 77°7′13″W  /  39.03667°N 77.12028°W  / 39.03667; -77.12028 Country   United States State   Maryland County Montgomery Area  • Total 8.9 sq mi (23.0 km 2 )  • Land 8.8 sq mi (22.9 km 2 )  • Water 0.0 sq mi (0.0 km 2 ) Elevation 394 ft (120 m) Population (2013 [1] )  • Total 46,646  • Density 4,281.5/sq mi (1,653.1/km 2 ) Time zone UTC−5 (Eastern (EST))  • Summer (DST) UTC−4 (EDT) ZIP codes 20814, 20817, 20851, 20852 Area code(s) 301 FIPS code 24-56337 GNIS feature ID 1867297 North Bethesda is an unincorporated, census-designated place in Montgomery County, Maryland, U

How to convert python datetime to timestamp and insert in oracle database using to_sql

Image
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I get DatabaseError: ORA-00904: "DAT_ULT_ALT": invalid identifier when I try to insert a datetime to a timestamp in oracle using to_sql from pandas with SQL Alchemy engine. My code: import sqlalchemy as sa import datetime import itertools ... oracle_db = sa.create_engine('oracle://username:password@host:port/database') connection= oracle_db.connect() ... dat_ult_alt = datetime.datetime.now() df_plano['DAT_ULT_ALT'] = pd.Series(list(itertools.repeat(dat_ult_alt, max))) df_plano.to_sql('table_name', connection, if_exists='append', index=False) This code works to field