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
ADVERTISEMENT
Feb 12, 2008
hello everone i have a table named "Concerned_Department" in which i ve a filed "Deadline"of type DateTime.i ve another table named "Cat_description" in wh i ve a filed "Max_Days"of type int in wh i ve values 1,2 and 3.in "Cat_Description" table i ve "Cat_ID" as Primary key of type int.all i want is if i select a row from "Cat_description" with "Max_Days"=1, i want to add this 1 to current date and and place it in the "deadline" field of "Concerned_Department" table.like if today is 12/02/2008 then i want to place 13/02/2008 in "Deadline" filed of "Concerned_Deprtment"tablewhen a row with "Max_Days"=1 from "Cat_Description" is selected.i am using SQL SERVER 2005 Exprees and C#(in source behind).regardsAhmed Bilal Jan
View 2 Replies
View Related
Oct 25, 2007
how is it possible to set a filed in a database to automatically add the current time to the filed at run time, is this possible; this filed has already been identified as 'DateTime' .
View 4 Replies
View Related
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
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
View Related
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
Apr 29, 2008
Hi,
I receive blanks for a column called value and i need to represent it as a blank or NA into a colum whose datatype is float in the datawarehouse.
how is this possible because in current schenario a blank is being converted to 0
which is not the right thing.
i would like to retain the blank in conversion from char to float ,
please explain me if it can be done or how to overcome this issue.
Thanks
View 1 Replies
View Related
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
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
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
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
Apr 6, 2004
My database has chinese characters in.
Eventually I need to only get the first 50 bytes of the data field, but somehow, I use len('==data==',50), it would catch 50 chinese characters which make 100 bytes ...
can anyone help me?
Thank you very much no matter what the result is ;)
View 1 Replies
View Related
Apr 22, 2008
Hello,
i have a table with million record, an bigint filed like:
ID Name
-------------------------------------
1 Adam
4 Bob
5 Daivid
100 ...
Also i have unique index on filed ID, i want update this filed for any row to get row number and to be like:
ID Name
-------------------------------------
1 Adam
2 Bob
3 Daivid
4 ...
Can any one show me sample code ?
Kind Regards,
sasan.
View 6 Replies
View Related
Apr 18, 2007
i have two tables .Table 1 contains certain columns with values.Table 2 shud get those data from table1 into its column and display the calculated result. Any idea how do i go abt it,bcuz table2 shud contain a formula so as to calculate.
View 5 Replies
View Related
Feb 10, 2004
I don't know there is Password filed in SQL 2000 or not ?
If there is not , then How to hidden password in database.
pls help me !
View 1 Replies
View Related
Apr 20, 2008
HELLO FRIENDS
HOW YOU DOING ? HOPE FINE AND HAPPY
I BIG PROBLEM WHICH IS SMALL FOR YOU
HERE IS MY SQL STATMENT
SQLString = "select F01,F02,F03,F04,F05,F06,F07 from MovementTable where f011= KLM and f06 between 2 and 4"
HOW CAN HAVE COUNT IF F02=3 , F03=4 ,F04=5 THE TOTAL SHOULD BE =12
THANKS IN ADVANCE
View 12 Replies
View Related
Apr 18, 2008
Hi All,
For one of my reports, I need a expression smthing like this.
=IIf(Fields!Category.Value = "Decisioned" , THEN SHOW SUMMATION OF TOTAL APPLICATIONS WHERE Catergory = "Decisioned ," ")
Can anyone help me to write this expression.
Thanks
View 3 Replies
View Related
Oct 20, 2004
I have a table with two primary key fileds. I will be running a process to populate the data into the table.For each process the first field is constant and second field is auto increment one.
My statements are insert into select ** from ** type one.
How do I auto increment second filed per run. Any delivered function available or any suggestion Pl.................
View 4 Replies
View Related
Jul 23, 2015
I want to CONCATENATE a field if the rows have the same Id. For example the data looks like
ID Name Identifier
1 ken English
1 Jack French
2 Jamie Spanish
3 Shirley German
The data should look like this if the IDs are same. I am concatenating the Identifier column with the name if the ids are same
ID Name Identifier
1 Ken English English
1 Jack French French
2 Jamie Spanish
3 Shirley German
View 8 Replies
View Related
Apr 14, 2008
Hi
I'm having two datetime field in my table. One is Call date and another one is Calltime because of some calculations. So I want to save calldate like 4/14/2008 and calltime like 9:30 PM.
Kindly help me.
View 3 Replies
View Related
Jun 18, 2007
Hello there
How are you? Hope fine and healthy
I have hug database which contain empty filed, I would like to fill the empty filed by inserting 0 in each empty filed using SQL command
May I have help please?
Thanks in advance
View 2 Replies
View Related
Aug 24, 2006
Hello I need to export my table fixed filed size by making numbers 15 characters right alignment and strings 20 characters left alignment.
View 1 Replies
View Related
Aug 24, 2006
Hello I need to export my table fixed filed size by making numbers 15 characters right alignment and strings 20 characters left alignment.
View 3 Replies
View Related
Nov 7, 2007
I have a database called ‘Objects’ which has many field. One of its fields is called ‘Image’ and has a data type image.
I want to add pictures to each one of my records offline, is this possible? i.e. by copying the address from my C drive such as C:Documents and SettingsfseyedarabiMy DocumentsMy Pictures
View 1 Replies
View Related
Feb 13, 2008
i ve a filed named "Email" of datatype .i ve created this field to insert email address in this field.but when i insert an email address like "bilal@yahoo.com" from a textbox wh is in an ASP.net webpage then in the filed i see this "System.Web.UI.WebControls.TextBox".
can u plz tell me how to fix this
Regards
Ahmed Bilal Jan
View 3 Replies
View Related
Jun 3, 2004
Hi,
I need to store large note in SQL Server field, what is substitute of Access's Memo filed in SQL Server?
Appreciated...
View 6 Replies
View Related
Jun 7, 2006
i am trying to insert an auot number field in my table which has got about million rows but sql 2005 is giving me na error "cant insert"
i need to index my table so that the query runs faster when i perform joins on two of such huge tables..
i tryid inserting the identity key the way it was mentioned in the forum but sql doesnt let me do that??
pls help
View 9 Replies
View Related
Apr 8, 2008
How can I validate the date that is coming across in a 8 byte character field via an expression? It will either be a valid date or 0. If it is zero I want to make it a null.
View 1 Replies
View Related
Oct 30, 2007
I have a database called 'objects' with one of its fields called 'Image' (data type is set to image) and a file in my desk top labelled as 'Pictures' (this is where all my pictures are keep). At run time i want to be able to select and add (upload) my preferred picture to the image filed of different records. Could you please advice me what i should do?
View 9 Replies
View Related
Jul 12, 2006
I have to run a dynamic sql that i save in the database as a TEXT data type(due to a large size of the sql.) from a .NET app. Now i have to run this sql from the stored proc that returns the results back to .net app. I am running this dynamic sql with sp_executesql like this..
EXEC sp_executesql @Statement,N'@param1 varchar(3),@param2 varchar(1)',@param1,@param2,GO
As i can't declare text,ntext etc variables in T-Sql(stored proc), so i am using this method in pulling the text type field "Statement".
DECLARE @Statement varbinary(16)SELECT @Statement = TEXTPTR(Statement)FROM table1 READTEXT table1.statement @Statement 0 16566
So far so good, the issue is how to convert @Statment varbinary to nText to get it passed in sp_executesql.
Note:- i can't use Exec to run the dynamic sql becuase i need to pass the params from the .net app and Exec proc doesn't take param from the stored proc from where it is called.
I would appreciate if any body respond to this.
View 2 Replies
View Related
Dec 29, 2005
Hi,
Following is the user defined function I want to get maximum value. It gives man an error "@strTableName must declare"
CREATE FUNCTION dbo.GetMaximum
(
@strFieldNamenvarchar(255),
@strTableName nvarchar(255)
)
RETURNS nvarchar(255)
AS
BEGIN
DECLARE @maxID int
SELECT @maxID=(SELECT IsNull(MAX(@strFieldName),0)+1 FROM @strTableName )
RETURN (@maxID)
END
View 5 Replies
View Related
Jan 11, 2008
Hi everyoneI am trying to create a DELETE Trigger. I have 2 tables. Table1 andTable2. Table 2 has all the same fields and records as Table1 + 1extra column "date_removed"I would like that when a record is deleted from Table 1, the triggerfinds that record in Table2 and updates the date_removed filed withcurrent time stamp.The primary key on both is combination of domain,admin_group and cn.CREATE TRIGGER [tr_updateTable2] ON [dbo].tbl_Table1FOR DELETEASUpdate Table2SET date_removed = getDate()I'm stuck here, how do I manipulate on Table2 only the records thatwere deleted on Table1, so to only update date_removed filed for themin Table2?I guess i need to compare domain, cn and admin_group, but I don't knowhow.Any help would be greatly appreciatedThanks! :-)
View 3 Replies
View Related
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
