如何将time_stamp转换为to_date [英] How to convert time_stamp into to_date

问题描述

我正在尝试构建一个桌面应用程序，通过pandas数据框从excel生成sql查询。我能够生成插入语句，但我正在以time_stamp格式（其中列是日期）接收数据，我想将其转换为to_date格式，请建议更好的方法来执行此操作。也建议通过使用相同的代码/同类产生选择/更新声明。

这是我期待的： -



插入ADI（ID，地址，城市，州，国家，超市名称，员工人数，日期）价值（1，'3666 21st St'，'旧金山'，'CA 94114'，'美国'，'马德拉' ，8，TO_DATE（'12 / 01/2018 00:00:00'，'MM / DD / YYYY HH24：MI：SS'）;

INSERT INTO ADI（ID，地址，城市，州，国家，超市名称，员工人数，日期）价值（2，'735 Dolores St'，'旧金山'，'CA 94119'，'美国'，'Bready Shop'，15，TO_DATE（'12 / 01 / 2018 00:00:00'，'MM / DD / YYYY HH24：MI：SS'）;

插入ADI（ID，地址，城市，州，国家，超市名称，数量员工，日期）价值（3，'332 Hill St'，'San Francisco'，'California 94114'，'USA'，'Super River'，25，TO_DATE（'12 / 01/2018 00:00:00'， 'MM / DD / YYYY HH24：MI：SS'）;

INSERT I NTO ADI（身份证，地址，城市，州，国家，超市名称，员工人数，日期）价值（4，'3995 23rd St'，'San Francisco'，'CA 94114'，'USA'，Ben's Shop ，10，TO_DATE（'12 / 01/2018 00:00:00'，'MM / DD / YYYY HH24：MI：SS'）;



建议怎么做，请不要建议用硬编码的方式来做： -

df [DATE] = df.DATE.dt.date

我正在构建一个应用程序，所以请建议如何以通用方式执行此操作。在此先感谢。



我尝试过：

I am trying to build an desktop app to generate sql queries from excel through pandas data frame. i am able to generate insert statement , but i am receiving data in time_stamp format(where column is date), i want convert it into to_date format,please suggest a better way to do this. also please suggest to generate select/update statement by making use of same code/same kind.
Here is what i expecting :-

INSERT INTO ADI (ID, Address, City, State, Country, Supermarket Name, Number of Employees, DATE) VALUES (1, '3666 21st St', 'San Francisco', 'CA 94114', 'USA', 'Madeira', 8, TO_DATE('12/01/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS');
INSERT INTO ADI (ID, Address, City, State, Country, Supermarket Name, Number of Employees, DATE) VALUES (2, '735 Dolores St', 'San Francisco', 'CA 94119', 'USA', 'Bready Shop', 15, TO_DATE('12/01/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS');
INSERT INTO ADI (ID, Address, City, State, Country, Supermarket Name, Number of Employees, DATE) VALUES (3, '332 Hill St', 'San Francisco', 'California 94114', 'USA', 'Super River', 25,TO_DATE('12/01/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS');
INSERT INTO ADI (ID, Address, City, State, Country, Supermarket Name, Number of Employees, DATE) VALUES (4, '3995 23rd St', 'San Francisco', 'CA 94114', 'USA', "Ben's Shop", 10, TO_DATE('12/01/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS');

Please suggest how to do this , and please don't suggest to do it in hardcode way like:-
df["DATE"] = df.DATE.dt.date
I am building an app , so please suggest how to do this in generic way. Thanks in advance.

What I have tried:

<pre lang="Python">

这是我的代码： -

来自pandas import *

table_name =ADI

file_name = pandas.read_excel（'supermarke.xlsx '）

def SQL_Insert（SOURCE，TARGET）：

sql_texts = []

索引，SOURCE.iterrows（）行： br />
sql_texts.append（

'INSERT INTO'+ TARGET +'（'+ str（'，'。join（SOURCE.columns））+'）VALUES'+ str （元组（row.values））+;）



return（'\ n'.join（sql_texts））

print（SQL_Insert（file_name，table_name））

Here is my code :-
from pandas import *
table_name="ADI"
file_name=pandas.read_excel('supermarke.xlsx')
def SQL_Insert(SOURCE, TARGET):
sql_texts = []
for index, row in SOURCE.iterrows():
sql_texts.append(
'INSERT INTO ' + TARGET + ' (' + str(', '.join(SOURCE.columns)) + ') VALUES ' + str(tuple(row.values))+";")

return ('\n'.join(sql_texts))
print(SQL_Insert(file_name, table_name))

Here is the result:-
INSERT INTO ADI (ID, Address, City, State, Country, Supermarket Name, Number of Employees, DATE)   VALUES (1, '3666 21st St', 'San Francisco', 'CA 94114', 'USA', 'Madeira', 8, Timestamp('2018-01-12 00:00:00'));
INSERT INTO ADI (ID, Address, City, State, Country, Supermarket Name, Number of Employees, DATE)   VALUES (2, '735 Dolores St', 'San Francisco', 'CA 94119', 'USA', 'Bready Shop', 15, Timestamp('2018-01-12 00:00:00'));
INSERT INTO ADI (ID, Address, City, State, Country, Supermarket Name, Number of Employees, DATE)   VALUES (3, '332 Hill St', 'San Francisco', 'California 94114', 'USA', 'Super River', 25, Timestamp('2018-01-12 00:00:00'));
INSERT INTO ADI (ID, Address, City, State, Country, Supermarket Name, Number of Employees, DATE)   VALUES (4, '3995 23rd St', 'San Francisco', 'CA 94114', 'USA', "Ben's Shop", 10, Timestamp('2018-01-12 00:00:00'));

推荐答案

< a href =https://www.google.com/search?q=string+to+date+python>字符串到目前为止python - Google搜索 [ ^ ]

这篇关于如何将time_stamp转换为to_date的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！