检索存储在INT类型中的日期 [英] To Retrieve date stored in type INT
问题描述
i有问题,这是问题....
i有表格,日期存储为int .....说对于
例如:日期:2006年11月30日时间:09:15 am存储在表中为1164896114
现在我需要比较这个日期并拔出与此日期相关的交易.....请告诉我使用的语法,它会很棒!
select * from table name where datefield =" 11/30 / 2006年" (请为我修改它的语法)
hi ,
i have a problem, here is the issue....
i have table with date stored as int.....say for
eg : date: 11/30/2006 time:09:15 am is stored in the table as 1164896114
now i need to compare this date and pull out the transaction related to this date.....please tell me the syntax to be used , it would be great!
select * from table name where datefield = "11/30/2006" (recorrect it the syntax for me please )
推荐答案
hi,
i有问题,这是问题....
i有表格,日期存储为int .....说
例如:日期:11 / 30/2006时间:09:15 am存储在表中为1164896114
现在我需要比较这个日期并提取与此日期相关的交易.....请告诉我语法如果要使用,那就太棒了!
从表名中选择*,其中datefield =" 11/30/2006" (请为我修改它的语法)
hi ,
i have a problem, here is the issue....
i have table with date stored as int.....say for
eg : date: 11/30/2006 time:09:15 am is stored in the table as 1164896114
now i need to compare this date and pull out the transaction related to this date.....please tell me the syntax to be used , it would be great!
select * from table name where datefield = "11/30/2006" (recorrect it the syntax for me please )
嗨。您的表可能存储日期时间字段,因此上述语法可能不起作用,因为您没有指定时间。如果要搜索特定日期,则应使用以下语法:
Hi. Your table will likely be storing datetime fields so the above syntax may not work as you are not specifying a time. If you want to search for a specific date you should use the following syntax:
嗨。您的表可能存储日期时间字段,因此上述语法可能不起作用,因为您没有指定时间。如果要搜索特定日期,则应使用以下语法:
Hi. Your table will likely be storing datetime fields so the above syntax may not work as you are not specifying a time. If you want to search for a specific date you should use the following syntax:
11 / 30/2006时间:09:15上午变成1164896114?
我认为它应该是113020060915
How 11/30/2006 time:09:15 am became 1164896114?
I would assume it should be 113020060915
这篇关于检索存储在INT类型中的日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!