Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
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
Who is Participating?
for sql
for basic
http://msdn.microsoft.com/en-us/library/az4se3k1%28v=vs.71%29.aspx
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx
DECLARE @dt DATETIME
set @dt = '2013-01-01'
select CONVERT(VARCHAR,@dt, 103)
for basic
http://msdn.microsoft.com/en-us/library/az4se3k1%28v=vs.71%29.aspx
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx
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.
All Courses
From novice to tech pro — start learning today.
Dim nusa1 As String = "update cheque set fechat='" & Today.ToString("dd/MM/yyyy