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

Microsoft SQL ServerVisual Basic.NETSQL

Last Comment

Ernesto

8/22/2022 - Mon

Haver Ramirez

1/7/2013

for sql

DECLARE  @dt DATETIME
set @dt = '2013-01-01'
select CONVERT(VARCHAR,@dt, 103)

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

Ernesto

1/7/2013

ASKER

i need it to put in vb.net code
tsm

deighton

1/7/2013

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.

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

James Murphy

Ernesto

1/7/2013

ASKER

is varchar
tsm
update the table with the todays date

yes it update the table

Ernesto

1/7/2013

ASKER

but i need to update with the system date
tsm

Haver Ramirez

1/7/2013

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")

Open in new window

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

Nasir Razzaq

1/7/2013

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") & "' where id='" & CustomerId & "'"

Ernesto

1/7/2013

ASKER

codecruise
almost
give me the date as 07/00/2013
when need to be 07/01/2013

tsm
almos please!!!

ASKER CERTIFIED SOLUTION

Nasir Razzaq

1/7/2013

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial