Javascript日期到sql日期对象 [英] Javascript date to sql date object
问题描述
我正在尝试编写一个带有Javascript日期对象的查询,然后将其放入SQL Server和Oracle数据库类型都可识别的对象类型中。
I'm trying to write a query that takes a Javascript date object and then puts it in an object type that is recognized by both SQL Server and Oracle database types.
问题是我正在使用webservices。所以它必须是一个字符串,而不是一个实际的传递参数。这就是我的意思:
The issue is that I'm using webservices. So it has to be a string, not an actual passed parameter. Here's what I mean:
var date = new Date();
var firstDayOfMonth = new Date(date.getFullYear(), date.getMonth(), 1);
var lastDayOfMonth = new Date(date.getFullYear(), date.getMonth() + 1, 0);
var webServicesQueryWhereClause = 'readDate BETWEEN '+firstDayOfMonth+' AND '+lastDayOfMonth;
除 firstDayOfMonth
和 lastDayOfMonth
被 to_date()
包围,以实际将它们置于数据库可读取的日期格式中。例如:
Except firstDayOfMonth
and lastDayOfMonth
are surrounded by something like to_date()
to actually put them in a date format that the databases can read. For example:
var webServicesQueryWhereClause = 'readDate BETWEEN to_date('+firstDayOfMonth+') AND to_date('+lastDayOfMonth+') ';
我应该使用什么来将这些日期放在SQL Server和Oracle都能读取的表单中?
What should I use to put those dates in a form that can be read by both SQL Server and Oracle?
推荐答案
您是否尝试过此处提供的解决方案:
Have you tried the solutions presented here:
< a href =https://stackoverflow.com/questions/5129624/convert-js-date-time-to-mysql-datetime>将JS日期时间转换为MySQL日期时间
标题应该被称为
将JS日期转换为SQL DateTime
"Convert JS date to SQL DateTime"
我碰巧需要和你刚才做同样的事情,在你的问题之后我遇到了这个问题。
I happened to need to do the same thing as you just now and I ran across this after your question.
这是来自Gajus Kuizinas的另一篇文章给那些想要的人本页面的答案:
This is from the other post by Gajus Kuizinas for those who want the answers on this page:
var pad = function(num) { return ('00'+num).slice(-2) };
var date;
date = new Date();
date = date.getUTCFullYear() + '-' +
pad(date.getUTCMonth() + 1) + '-' +
pad(date.getUTCDate() + ' ' +
pad(date.getUTCHours() + ':' +
pad(date.getUTCMinutes() + ':' +
pad(date.getUTCSeconds();
或
or
new Date().toISOString().slice(0, 19).replace('T', ' ');
第一个对我有用。我对toISOString有一个参考问题,虽然我更喜欢一个衬垫。任何人都可以澄清如何使用它并了解其局限性在哪里可以参考它?
祝你好运!
The first one worked for me. I had a reference problem with the toISOString as well although I would prefer the one liner. Can anyone clarify how to use it and know the limitations on where one can reference it? Good luck!
这篇关于Javascript日期到sql日期对象的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!