.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Converting datetime to var``char without changing the format

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
 

Hi Team,

Is there a way to change the datetime to varchar without changing the format

like datetime '2009-09-28 00:00:00.000' after converting to varchar it should be in the same format

Thanks,

Eshwar




View Complete Post


More Related Resource Links

string not converting in datetime format

  

hi to all,

 i'm developing a website. i have a registration form where user can registered with this website.

this have a birthdate field for store user's birthdate.that is a textbox.

here is my code.

protected void submitbtn_Click(object sender, ImageClickEventArgs e)
{
System.Globalization.CultureInfo en = new System.Globalization.CultureInfo("en-GB");
li.fname = firstname.Text;
li.lname = lastname.Text;
li.gender = gender.SelectedItem.Text;
li.date = Convert.ToDateTime(birthdate.Text,en); //getting error here
li.address = addrs.Text;
li.contactno = contno.Text;
li.countryid =Convert.ToInt32( dropcontry.SelectedValue);
li.stateid = Convert.ToInt32( dropstate.SelectedValue);
li.cityid =Convert.ToInt32( dropcity.SelectedValue);
li.emailid = prmrmailid.Text;
li.username = createuserid.Text;
li.password = createpassword.Text;
li.secutityque = dropsecque.SelectedItem.Text;
li.securityans = secanswer.Text;
li.registrationform(li);

li.lastselect();
int a = li.personid;
li.personid= a;
li.insrtusername(li);
li.lastselect();
int p = li.personid;
li.questioninsrt(li);
}

How to format datetime & date with century?

  
Execute the following Microsoft SQL Server T-SQL datetime, date and time formatting scripts in Management Studio Query Editor to demonstrate the usage of the multitude of temporal data formats available and the application of date / datetime functions.

http://www.sqlusa.com/bestpractices2005/centurydateformat/

Video: Converting Word Documents to PDF Format Using SharePoint Server 2010 and Word Services

  
Watch this visual how-to video as you learn how to programmatically convert Word documents to PDF format on the server by using Word Automation Services with SharePoint Server 2010. (Length: 6:15)

Convertion failed when converting datetime to String

  
DECLARE @usr datetime SET @usr = user+'::Date' IF NOT EXISTS (SELECT 'X' FROM table WHERE Name = 'File' AND CONVERT(varchar,DateAdd, 101) = CONVERT(varchar, getdate(), 101)) BEGIN INSERT INTO table (Code, Name, Date) VALUES ('DD', 'File',@usr) END the date will be created by another process and its value will be loaded in the variable DATE. I'm calling that variable here. I;m getting the error Convertion failed when converting datetime to String. how to resolve this..??

Convertion failed when converting datetime to String

  
DECLARE @usr datetime SET @usr = user+'::Date' IF NOT EXISTS (SELECT 'X' FROM table WHERE Name = 'File' AND CONVERT(varchar,DateAdd, 101) = CONVERT(varchar, getdate(), 101)) BEGIN INSERT INTO table (Code, Name, Date) VALUES ('DD', 'File',@usr) END I;m getting the error Convertion failed when converting datetime to String. how to resolve this..??

Datetime format in textbox

  
Hi I'm retrieving a datetime type of data from sql table databaseMy problem is when I'm retriving it to my textbox it appear something like this -->> 1/10/1990 12:00what i want is to remove the time and appear like this only ---> 1/10/1999 How can I do this?btw I'm using c# Thanks in advance!

DateTime format from sql DataSet

  
Hello,This is probably a very common question.  But I have a Text Box that is being populated from the database when the page is loaded.  But is displays the time as 8/30/2010 12:00:00 AM.  I need this 8/30/2010.  In the database is it storing the date and time.  I have this which is where the text box is being populated.txt_EventDate.Text = ds.Tables[0].Rows[0]["EventDate"].ToString();How am I able to get rid of the 12:00:00 AM???Thank youvery much!!

DateTime format

  
Hi, Can anybody tell me how to load todays date in a textbox in dd/MM/yyyy format i used this  txtFromDate.Text = DateTime.Now.ToString("dd/MM/yyyy") I am getting the output as 01-09-2010, but i want my output as 01/09/2010Hi,Can anybody tell me how to load todays date in a textbox in dd/MM/yyyy formati used this txtFromDate.Text = DateTime.Now.ToString("dd/MM/yyyy")I am getting the output as 01-09-2010, but i want my output as 01/09/2010

Format datetime in <%#DataBinder.Eval(Container.DataItem, "DBDate")%>

  
I have a date in a database which i bring into a repeater using <%#DataBinder.Eval(Container.DataItem, "DBDate")%>.  Can I format the datetime which is write to remove the time bit from it.  At the moment it is written in this format:25/02/2007 00:00:00. I want it to be 25/02/2007 or even a more readable date such as February 25th 2007. Thanks Andrew

Converting DateTime to SmallDateTime when OUTER JOIN

  
Hi, Here is the situation: I have a query with the following format:       Select a.*, b.* from (select col1, col2 from tbl1 t1 left join tbl2 t2 on t1.x = t2.x where t1.colSmallDateTime= MAX(t.ColDateTime)) a                     LEFT OUTER JOIN (select col1, col2 from tbl1 t1 left join tbl2 t2 on t1.x = t2.x where t1.colSmallDateTime= MIN(t.ColDateTime)) b                     ON (a.y = b.y) When i tun this query i get the following error:            Msg 298, Level 16, State 1, Line 1            The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error. Does anyone have any idea why i am getting this error? Thank in advance for your help!  

datetime format datatabase

  
how can i select datetime field as this format dd/MM/yyyy HH:mm:ss

sql datetime format

  
how can i convert date format from sql to dd/MM/yyyy HH:mm:ss

Format Datetime Parameter Label

  
I'm trying to format the label of a parameter which is populated by a dropdown in SQL2008 RS. Essentially, i want to put a title in the report which puts the date in the format dd MMM yyyy. I have tried the following options with no luck: =Format(Parameters!MyDate.Label, "dd MMM yyyy") =Format(CDate(Parameters!MyDate.Label), "dd MMM yyyy") Can this be achieved in this way? I "could" reformat the data in the dataset, but i'd rather explore this avenue first. TIAevery day is a school day

Format DateTime in TemplateField

  
Hi, I am looking to format a date to format dd/mm/yyyy for a template field but I can't seem to get the syntax right. I think it is because my template field links to the method of an object. The template field is:<asp:TemplateField HeaderText="Date Of Accident">                    <ItemTemplate>                        <%#((AccidentObject)(Container.DataItem)).getAccidDate() %>                    </ItemTemplate>                </asp:TemplateField>And all the the stuff on the internet says to format it bythis format<%# Bind("DOB","{0:D}") %>This doesn't work for me I would say because I am using a method. Any help would be really appreciated. Seamus

Converting string to DateTime

  
Hello, I am trying to figure out the best way to convert a string object into a DateTime with only using the year.I have something like:Date Time HSYear = DateTime.ParseExact(HighSchoolyear, "yyyy", System.Globalization.CultureInfo.CurrentCulture); But it is still giving a "String was not a recognized as a valid DateTime."In the full context, I have a webpage with a formview on it and within the formview is a TextBox control that is taking a user input such as "1999"  then an ObjectDataSource picks it up and runs it through a BLL. And within the BLL is where I am trying to convert it before it gets inserted into the database.

Help to resolve an error "The conversion of a char data type to a datetime data type resulted in an

  
Why am I getting an error when executing this: select convert(datetime, '2010-09-12T18:11:48', 120) The message is: "Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." I don’t get the error if I remove “T” from the string. But I need it to work with “T”.

converting string to datetime and then to shortdate?/

  
Hi,I have a field (varchar) field that holds date.  Some data was transferred to this column but the transferred data was a timestamp (datetime in the format of say 10/26/2009 4:54:13 AM).  Now, I need to modify the new table to only contain 10/26/2009.  How can I write a statement to delete the time leavin gonly 10/26/2009??  I can use trim function but the # of characters vary as the date might be 1/10/2010 12:50:00 PM, etc....?thanks .
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend