date-arithmetic
Get Date from a long var char milliseconds value stored in oracle Database
I have a date store in data base as a long value in varchar eg: 1230748200000. I need to get the year out from it withing the oracle query..how can i please do it in oracle? is there a way that i can[详细]
2023-01-27 08:28 分类:问答What is the recommended way of doing date arithmetics in Perl?
What is the recommended way of doing date arithmetics in Perl开发者_C百科? Say for example that I want to know the date three days ago from today (where today = 2010-10-17 and today - 3 days = 2010-1[详细]
2023-01-20 03:27 分类:问答how can I add 100 years to a date in Advantage Database
I have a bunch of records in my Advantage Database that ended up with the year 1909, rather than 2009.How can run an update statement that will add 100 years to each of these d开发者_开发百科ates?(Adv[详细]
2023-01-18 00:18 分类:问答Comparing dates in Oracle using the decode function
I need to compare two dates using the Oracle decode开发者_如何学JAVA function to see if one is less than or equal to the other.[详细]
2023-01-13 20:25 分类:问答oracle 10g submit job function error
I\'m trying to schedule a job in oracle 10gbut it says: ORA-01846: not a valid day of the week. Heres my code:[详细]
2023-01-11 19:41 分类:问答Regarding date in sql
Here\'s my que开发者_如何学运维ry: select * from test n WHERE lower(process_name) like \'test%\'[详细]
2023-01-11 14:50 分类:问答What I have minus months in database (mysql), is it the php code?
Description: I am doing purchasing function, whenever the users make purchases, it will add 1 month privilege to my access special page of my site. I have received some complaints from my users, plea[详细]
2023-01-10 16:48 分类:问答Add DATE and TIME fields to get DATETIME field in MySQL
I am trying to get a DATETIME field from a DATE and a TIME field. none of the functions in MYSQL seems useful.开发者_开发百科[详细]
2023-01-08 04:05 分类:问答SQL Server version of Oracle's ADD_MONTHS()
In Oracle, you can use ADD_Months to add months on the fly in the sql statement. What is the MS SQL version.[详细]
2023-01-06 07:52 分类:问答Oracle 10g-Express Query
I want to perform a special query on a table in my oracle database. I want the result to be sorted according to an enum that I have.[详细]
2023-01-05 19:05 分类:问答