Problem With Datatime

Apr 20, 2004

Hi everybody.
I am new in SQL SERVER and I have a problem with a datetime

I have a select. It works in a database but
it doesn´t work in other database.

The error is the next :

2004-04-20 13:37:32,781 INFO [STDOUT] ConexionBDExceptionjava.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

The select is:

SELECT id_solicitud from solicitudes where
fecha_apertura >= '01/03/04'
AND fecha_apertura <= '31/03/04 23:59:59.999'
ORDER BY fecha_apertura DESC

Thanks for attention.
PILAR

View 2 Replies


ADVERTISEMENT

How To Use Like With DataTime ???...

Mar 5, 2007

i want to fetch visitors record by data but visiting date field has time also and i want to get by data only because i am unknown to exact time.
i am using this query but record  does not comes.
select * from visitors where in_date_time like '03-05-2007%'
where as i am using visitor name instead of in_data_time it works success fully.
plz solve it.
Jasim...
New Delhi...

View 1 Replies View Related

Datatime Error

Jul 23, 2005

I have some problem with datatime.SELECT * FROM stat WHERE data > '2005-05-24 14:07:28' ORDER BY id AscI got the error:Microsoft OLE DB Provider for SQL Server error '80040e07'The conversion of a char data type to a datetime data type resulted in anout-of-range datetime value.Why? Format of date is the same in database?Regards,

View 8 Replies View Related

DataTime For Linked Server

Sep 23, 2007

DataTime for linked Server
I have a SQL server in Country A (Server A) and another Server in Country B (Server B) Server A has Server B as linked server, I run a stored procedure in Server A and getdate()gives me current date/time for Server A, how can I do getdate() for Server B?
 

View 3 Replies View Related

DataTime For Linked Server

Sep 23, 2007


DataTime for linked Server
I have a SQL server in Country A (Server A) and another Server in Country B (Server B) Server A has Server B as linked server, I run a stored procedure in Server A and getdate()gives me current date/time for Server A, how can I do getdate() for Server B?

View 2 Replies View Related

SQL Express Datatime Defualt

Apr 28, 2008

Hi everybody

I pages and use Ms sql Express and would like to have it condition-shape defual value to be the date, but if I choose the field have to be date-hour and then defual value chooses have nowly () to be it doesn't give myself any law, some that know what I do mistakes here?

View 2 Replies View Related

How Can I Make Datatime Filed A Blank?

Aug 14, 2001

How can I make datatime filed a blank?

For example,


create table abc (day1 datetime, day2 datetime)
insert into abc values ('2001-08-09, '2001-08-13')
insert into abc values ('2001-08-10, '')
insert into abc values ('2001-08-11', '2001-08-15')

If i execute the above sql then I will have,

Day1 day2
==== ====
2001-08-09 2001-08-13
2001-08-10 1900-01-01
2001-08-11 2001-08-15

But I want to have the following result,
Day1 day2
==== ====
2001-08-09 2001-08-13
2001-08-10
2001-08-11 2001-08-15

How can I insert blank value in day2 column?
Thanks in advance

View 1 Replies View Related

Transact SQL :: How To Get Difference To Two Datatime In Seconds Using Logparser Query

Sep 23, 2015

In sql we have a built in function

DATEDIFF(second, startdate, enddate)

How can we achieve the same using Log parser query for date time in format (2015-09-22 10:25:30.5220)

Example:

startdate = 2015-09-22 10:25:30.5220.
Enddate = 2015-09-22 10:26:30.5220

After DateDiff I need to get 6 seconds.

View 5 Replies View Related

Modify Nvarchar Datatype To Datatime Datatype

Mar 14, 2008

Hi,

I imported a table from Accees to SQL 7 with data in it.
I need to modify one of the datatype columns to "datetime" from nvarchar.

I tried to convert it manually, in SQL Server Enterprise Manager tool, but it gave me an error.

I also tried, creating another column "DATE2-datatype:datetime" and updating the column with the old one.

UPDATE users SET DATE2 = DATE.. But it also faild,..

How can I modify the column?

Thank you.

View 10 Replies View Related

When Have 4 Tables How To Compare Table With 4nd Table? ( Need To Join And Compare With Datatime)

Jul 22, 2007

Table MediaImportLog
column ↘ImportIndex     ImportFileTime            ImportSource
value    ↘80507             20060506001100          815
              80511             20061109120011           CRD                       ã€? P.S the values type of ImportFileTime 20060506001100 → 2006 -year 05-month 06-day 00-HH 11-minute 00-second】
Table  BillerChain
column↘BillerInfoCode       ChainCode
value   ↘750                      815
value   ↘81162                  CRD
Table   Biller
column↘CompanyCode         BillerCode
value   ↘999                     750
value   ↘81162                  516
TAble DataBackup
column↘CompanyCode         Keepmonth
value   ↘999                     6
value   ↘81162                 12
 
---------------------------------------------------
 
when I'm in MediaImportLog , I want use column ImportSource to compare with column ChainCode in table BillerChain ( so I get BillerInfoCode) and then use the BillerInfoCode I got to compare with column BillerCode in Table Bill ( I get CompanyCode) finally I use CompanyCode to compare with column CompanyCode in table DataBackup so I can get the company's keepmonth
How can I get the keepmonth? can I use parameters ? 
 
thank you very much 

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved