There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
get today date format dd/mm/yyyy sql visual.net
Hi, all
is any way to achive
Dim nusa1 As String = "update cheque set fechat=today format (dd/mm/yyyy) where id='" & CustomerId & "'"
Dim cmd11 As New OleDbCommand(nusa1, cn)
cmd11.ExecuteScalar()
I need retrive the today date format dd/mm/yyyy
tsm
is any way to achive
Dim nusa1 As String = "update cheque set fechat=today format (dd/mm/yyyy) where id='" & CustomerId & "'"
Dim cmd11 As New OleDbCommand(nusa1, cn)
cmd11.ExecuteScalar()
I need retrive the today date format dd/mm/yyyy
tsm
Asked:
-
6
2
2- +1
1 Solution
what is the data type of field fechat?
Are you wanting to retrieve data from the table or update the table?
The code you showed us updates the table. I believe there is no select so it retrieves no data.
Are you wanting to retrieve data from the table or update the table?
The code you showed us updates the table. I believe there is no select so it retrieves no data.
save in a variable,
Dim dtNow as Datetime
Dim nusa1 As String = "update cheque set fechat= getdate() where id='" & CustomerId & "'"
Dim cmd11 As New OleDbCommand(nusa1, cn)
dtNow = Cast(cmd11.ExecuteScalar() as datetime)
' later format you datetime value
dim strFormat as string
strFormat = Format(dtNow,"dd/MM/yy")
Change this
Dim nusa1 As String = "update cheque set fechat=today format (dd/mm/yyyy) where id='" & CustomerId & "'"
to
Dim nusa1 As String = "update cheque set fechat='" & Today.ToString("dd/mm/yyyy
Dim nusa1 As String = "update cheque set fechat=today format (dd/mm/yyyy) where id='" & CustomerId & "'"
to
Dim nusa1 As String = "update cheque set fechat='" & Today.ToString("dd/mm/yyyy
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Open in new window
for basic
http://msdn.microsoft.com/en-us/library/az4se3k1%28v=vs.71%29.aspx
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx