A bug was filed against RDO for the installation of Keystone v3. This guide is designed to walk you through the configuration for using Keystone v3 with Packstack. You will accomplish this using various repos and the Answers file.
Course Of The Month
9 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
get today date format dd/mm/yyyy sql visual.net
Posted on 2013-01-07
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
6
2
2- +1
11 Comments
Active 3 days ago
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.
Active 3 days ago
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")
Active 4 days ago
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
Active 1 day ago
codecruise
almost
give me the date as 07/00/2013
when need to be 07/01/2013
tsm
almos please!!!
almost
give me the date as 07/00/2013
when need to be 07/01/2013
tsm
almos please!!!
Featured Post
Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this article we will learn how to fix “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 7 hours left to enroll
624 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.