how to convert string to mysql date format using vb.net?
1
i want to insert a string as date format in mysql table using vb.net.my code is given below.but i always get an error .the string is stored in an array.
mycode
------
Dim sdfsa As String = Convert.ToDateTime(newarray(i + 17)).ToShortDateString().ToString("yyyy-MM-dd")
Dim newdate As Date = DateTime.ParseExact(sdfsa, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
datarw("date_of_birth") = newdate
mysql vb.net
edited Apr 11 '12 at 11:29
Ali Issa
4,11383366
asked Feb 29 '12 at 7:02
ssassa
1729
add a comment |
1
i want to insert a string as date format in mysql table using vb.net.my code is given below.but i always get an error .the string is stored in an array.
mycode
------
Dim sdfsa As String = Convert.ToDateTime(newarray(i + 17)).ToShortDateString().ToString("yyyy-MM-dd")
Dim newdate As Date = DateTime.ParseExact(sdfsa, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
datarw("date_of_birth") = newdate
mysql vb.net
edited Apr 11 '12 at 11:29
Ali Issa
4,11383366
asked Feb 29 '12 at 7:02
ssassa
1729
add a comment |
1
1
1
i want to insert a string as date format in mysql table using vb.net.my code is given below.but i always get an error .the string is stored in an array.
mycode
------
Dim sdfsa As String = Convert.ToDateTime(newarray(i + 17)).ToShortDateString().ToString("yyyy-MM-dd")
Dim newdate As Date = DateTime.ParseExact(sdfsa, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
datarw("date_of_birth") = newdate
mysql vb.net
edited Apr 11 '12 at 11:29
Ali Issa
4,11383366
asked Feb 29 '12 at 7:02
ssassa
1729
i want to insert a string as date format in mysql table using vb.net.my code is given below.but i always get an error .the string is stored in an array.
mycode
------
Dim sdfsa As String = Convert.ToDateTime(newarray(i + 17)).ToShortDateString().ToString("yyyy-MM-dd")
Dim newdate As Date = DateTime.ParseExact(sdfsa, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
datarw("date_of_birth") = newdate
mysql vb.net
mysql vb.net
edited Apr 11 '12 at 11:29
Ali Issa
4,11383366
asked Feb 29 '12 at 7:02
ssassa
1729
edited Apr 11 '12 at 11:29
Ali Issa
4,11383366
asked Feb 29 '12 at 7:02
ssassa
1729
edited Apr 11 '12 at 11:29
Ali Issa
4,11383366
edited Apr 11 '12 at 11:29
Ali Issa
4,11383366
edited Apr 11 '12 at 11:29
Ali Issa
4,11383366
4,11383366
asked Feb 29 '12 at 7:02
ssassa
1729
asked Feb 29 '12 at 7:02
ssassa
1729
asked Feb 29 '12 at 7:02
ssassa
1729
1729
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
0
Are the Users inputting this information directly?
if they are why don't you input have them input the value in a masked text box?
This Link Could Help
answered Feb 29 '12 at 7:12
Jon CrawleyJon Crawley
3616
add a comment |
0
Try this:
my_date =Format(Now,"yyyy-MM-dd")
answered Feb 29 '12 at 7:19
VinodVinod
3,09731425
add a comment |
0
Example
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim year, month, day As Integer
Dim date_value As Date
Dim date_final_to_mySQL As String
date_value = DateTimePicker1.Value
year = date_value.Year
month = date_value.Month
day = date_value.Day
date_final_to_mySQL = year & "-" & month & "-" & day
MessageBox.Show(date_final_to_mySQL)
End Sub
Only need create a button1 and datetimepicker1
Final Result
answered Nov 21 '18 at 20:06
PerroniPerroni
45
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f9494864%2fhow-to-convert-string-to-mysql-date-format-using-vb-net%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Are the Users inputting this information directly?
if they are why don't you input have them input the value in a masked text box?
This Link Could Help
answered Feb 29 '12 at 7:12
Jon CrawleyJon Crawley
3616
add a comment |
0
Are the Users inputting this information directly?
if they are why don't you input have them input the value in a masked text box?
This Link Could Help
answered Feb 29 '12 at 7:12
Jon CrawleyJon Crawley
3616
add a comment |
0
0
0
Are the Users inputting this information directly?
if they are why don't you input have them input the value in a masked text box?
This Link Could Help
answered Feb 29 '12 at 7:12
Jon CrawleyJon Crawley
3616
Are the Users inputting this information directly?
if they are why don't you input have them input the value in a masked text box?
This Link Could Help
answered Feb 29 '12 at 7:12
Jon CrawleyJon Crawley
3616
answered Feb 29 '12 at 7:12
Jon CrawleyJon Crawley
3616
answered Feb 29 '12 at 7:12
Jon CrawleyJon Crawley
3616
answered Feb 29 '12 at 7:12
Jon CrawleyJon Crawley
3616
3616
add a comment |
add a comment |
0
Try this:
my_date =Format(Now,"yyyy-MM-dd")
answered Feb 29 '12 at 7:19
VinodVinod
3,09731425
add a comment |
0
Try this:
my_date =Format(Now,"yyyy-MM-dd")
answered Feb 29 '12 at 7:19
VinodVinod
3,09731425
add a comment |
0
0
0
Try this:
my_date =Format(Now,"yyyy-MM-dd")
answered Feb 29 '12 at 7:19
VinodVinod
3,09731425
Try this:
my_date =Format(Now,"yyyy-MM-dd")
answered Feb 29 '12 at 7:19
VinodVinod
3,09731425
answered Feb 29 '12 at 7:19
VinodVinod
3,09731425
answered Feb 29 '12 at 7:19
VinodVinod
3,09731425
answered Feb 29 '12 at 7:19
VinodVinod
3,09731425
3,09731425
add a comment |
add a comment |
0
Example
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim year, month, day As Integer
Dim date_value As Date
Dim date_final_to_mySQL As String
date_value = DateTimePicker1.Value
year = date_value.Year
month = date_value.Month
day = date_value.Day
date_final_to_mySQL = year & "-" & month & "-" & day
MessageBox.Show(date_final_to_mySQL)
End Sub
Only need create a button1 and datetimepicker1
Final Result
answered Nov 21 '18 at 20:06
PerroniPerroni
45
add a comment |
0
Example
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim year, month, day As Integer
Dim date_value As Date
Dim date_final_to_mySQL As String
date_value = DateTimePicker1.Value
year = date_value.Year
month = date_value.Month
day = date_value.Day
date_final_to_mySQL = year & "-" & month & "-" & day
MessageBox.Show(date_final_to_mySQL)
End Sub
Only need create a button1 and datetimepicker1
Final Result
answered Nov 21 '18 at 20:06
PerroniPerroni
45
add a comment |
0
0
0
Example
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim year, month, day As Integer
Dim date_value As Date
Dim date_final_to_mySQL As String
date_value = DateTimePicker1.Value
year = date_value.Year
month = date_value.Month
day = date_value.Day
date_final_to_mySQL = year & "-" & month & "-" & day
MessageBox.Show(date_final_to_mySQL)
End Sub
Only need create a button1 and datetimepicker1
Final Result
answered Nov 21 '18 at 20:06
PerroniPerroni
45
Example
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim year, month, day As Integer
Dim date_value As Date
Dim date_final_to_mySQL As String
date_value = DateTimePicker1.Value
year = date_value.Year
month = date_value.Month
day = date_value.Day
date_final_to_mySQL = year & "-" & month & "-" & day
MessageBox.Show(date_final_to_mySQL)
End Sub
Only need create a button1 and datetimepicker1
Final Result
answered Nov 21 '18 at 20:06
PerroniPerroni
45
answered Nov 21 '18 at 20:06
PerroniPerroni
45
answered Nov 21 '18 at 20:06
PerroniPerroni
45
answered Nov 21 '18 at 20:06
PerroniPerroni
45
45
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f9494864%2fhow-to-convert-string-to-mysql-date-format-using-vb-net%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
