Format DateTime in TemplateField

first table

Area_code (varchar)    Loan_date (datetime)

USA                             9/21/2009  12:00:00 AM

CAN                            10/22/2010  12:00:00 AM

ARG                            12/23/2009 12:00:00 AM

Second table

Area_code (varchar)    Date_format(varchar)

USA                             dd/mm/yy

CAN                             yy.d.m

ARG                            yy'?'d'?'m'?'

I want to add Loan_date column in second table and nee

I have a table in my SQL DB that is a DateTime table, what I want to do is take the numeric datetime it stores and convert it to a long date (i.e. 12/12/2012 conversts to December 12, 2012). Seaching the forums it looks like the string.format is the way to go and searching for info on that I found http://www.csharp-examples.net/string-format-datetime/ which lists all the different formats but they do not list a formating string to convert to the format I want to use. Does anyone know what format string I would use to convert a numeric date to a long date like I want? And can you show it in a code example because I am not 100% sure I understand the code examples shown on that site.

Hi, i have a textbox which contains datetime, i select date with calender extender.

In Local, i must enter dd.MM.yyyy format

but in IIS, i must enter MM.dd.yyyy format

How can i solve this ?? i'm trying to enter dd.MM.yyyy in iis too.

I have dates in my listview with the format "10/08/23,18:16:26-20".

when i am sending this to my database table, it is shown as " 2023-10-09 09:16:26.000".

cmd.Parameters.Add("@ActionDate", SqlDbType.DateTime).Value = Convert.ToDateTime(lvwMessages.Items[i].SubItems[1].Text);

Any help is appreciated.

Pratap!

when my system date separator set to "-", the following return the date format with "dd-mm-yyyy HH:mm"

DateTime b = DateTime.ParseExact(date, "dd/MM/yyyy HH:mm", provider);
                            strDate = b.ToString("dd/MM/yyyy HH:mm");

return strDate;

why? how can i return the dayeformat with "/" separator ingore PC datatime setting

 if i have field datetime =  2010-09-08 11:31:59.123
2010-09-08 17:42:08.737   2010-09-09 9:42:08.737 

how can i group by only date? Eg: 2010-09-08 = 2 record    2010-09-09 = 10 record

currently when i use group by datetime.. because of the time differece, so it show out all the row. Please help

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);
}

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