datetime format - Visual Basic .NET

Esref Durna

my sql server have this datetime format ( yyyy-mm-dd )
how could i change it to dd.mm.yyyy format
or what should i do?
thanks

Nov 20 '05 #1

Subscribe Post Reply

1199

Dhaval Faria

I also had a same prob with the dateformat in my application, for this what
I did, I used datetimepicker control, and I get data from SQL Database to
the datetimepicker and then can easily get the format dd/mm/yyyy or
alternate way is to store date in string format in SQL Database and then get
it from the database and if you store date in SQL Database as dd/mm/yyyy
itself then no need to convert but, if its in mm-dd-yyyy then take it in
datetimepicket control and then you can get date in format you want.. it can
be done by the following way...

datetimepickercontrol.values.day & "/" & datetimepickercontrol.values.month
& "/" & datetimepickercontrol.values.year

this gives date in DD/MM/YYYY format.

Hope this helps.

--
Dhaval Faria
Founder, Programmer
Hirdhav (http://www.hirdhav.com)
Microsoft India Community Star
"Esref Durna" <99****@students.emu.edu.tr> wrote in message
news:ep**************@TK2MSFTNGP09.phx.gbl...

my sql server have this datetime format ( yyyy-mm-dd )
how could i change it to dd.mm.yyyy format
or what should i do?
thanks

Nov 20 '05 #2

Similar topics

DateTime AddMinutes Format Issue

by: Fritz Switzer | last post by:

I'd like to have a string assigned the value of a DateTime.AddMinutes(amount) so that the string is formatted in "HH:MM" format. For example: DateTime.Now.AddMinutes(30) returns "00:30" ...

C# / C Sharp

String to DateTime

by: nobody | last post by:

I know that given a FormatString and a DateTime you can use DateTime.ToString(...) to convert the DateTime to a String. My question is how can you turn that around? Given a String and a...

Visual Basic .NET

dateTime Manupulations

by: Reny J Joseph Thuthikattu | last post by:

Hi, I have a variabe in the format of 'DD-MON-YYYY HH:MI AM' .I want to add a miniute to it.How can i do that? by manipulation i want to make '01-JUNE-2004 11:59 PM' to '02-JUNE-2004 12:00 AM'...

Visual Basic .NET

Globalization versus DateTime.ParseExact

by: Cor Ligthert | last post by:

Hello everybody, Jay and Herfried are telling me every time when I use CDate that using the datetime.parseexact is always the best way to do String to datetime conversions. They don't tell why...

Visual Basic .NET

Insert DateTime Value In DB Table?

by: Arpan | last post by:

A SQL Server 2005 DB table has 4 columns namely "ID" (IDENTITY int column), "FirstName" (varchar(50)), "LastName" (varchar(50)) & "DOB" (datetime). Now when I am trying to add a new row using the...

ASP.NET

DateTime.Parse()

by: js | last post by:

I have a textbox contains text in the format of "yyyy/MM/dd hh:mm:ss". I need to parse the text using System.DateTime.Parse() function with custom format. I got an error using the following code. ...

ASP.NET

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA