检索存储在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