I have a table named News in sql 2000, and I have a column named publishdate with datetime in News table, I read data through dataset like this:

          ' DsNews2 is dataset
           SqlDataAdapter1.FillSchema(DsNews2, SchemaType.Source, "News")
           SqlDataAdapter1.Fill(DsNews2, "News")

               Dim tb2 As DataTable
               tb2 = DsNews2.Tables("News")
               currentID = Integer.Parse(Request.QueryString("ID"))
               Dim drCurrent2 As DataRow
               drCurrent2 = tb2.Rows.Find(currentID)

               Dim pDate As DateTime = drCurrent2("Publishdate")

               Dim pdate As String = pDate.ToString()

i put my project in two machine and I got two different value from pdate, one is like:
2005-11-22 0:00:00
the other one is like:
11/22/2005 12:00:00 AM

I wonder I do I make sure that no matter in what machine, the value of pdate alway to be like the first one: 2005-11-22 0:00:00

by the way, can I remove '0:00:00' part?

many thanks for your help!
:(

Hi,

   There's nothing wrong in saving the date in SQL Server. But when showing a date field it shows according to the Regional settigs in your machine. That's why you get the date in 2 different formats from those 2 machines.

   To overcome this, format the date before showing it. Use this method to format dates.

Dim dt As DateTime
dt = DateTime.Now
Console.WriteLine(String.Format("{0:D}", dt))

D - paramater to convert the date in to long date format.

Here are some more options for formatting date-time values.

# d: The value is converted to the short date pattern.
# D: The value is converted to the long date pattern.
# t: The value is converted to the short time pattern.
# T: The value is converted to the long time pattern.
# f: The value is converted to the full date-time pattern, including short time.
# F: The value is converted to the full date-time pattern, including long time.
# g: The value is converted to the short date and short time.
# G: The value is converted to the long date and long time.
# M or m: The value is converted to the month day pattern.

thanks very much mate, that's very helpful!!!

Hi,

UR welcome buddy.