Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date format

Status
Not open for further replies.
2009luca

2009luca

Programmer
Jul 27, 2013
222
IT
I use a linked Teradata Table on Access Database.
I use Access database with Vb6 and Ado.
I need a suggestion to set a correct format in Sql String of the linked Teradata table.

Actually i use SQL="...where data1="# & format(Data3,"mm/dd/yyyy") & "#"... on teradata table, but not sure!

A friend tell me to use internation date sa. "YYYY-MM-DD" instead "mm/dd/yyyy", correct?
 
Status
Not open for further replies.

Similar threads

tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
189
tmcrouse
tmcrouse
Preshit
  • Locked
  • Question
Number of working days between two date fields
Replies
1
Views
209
johnherman
johnherman
nambir
  • Locked
  • Question
NEED TO TEST ON THREE DIFFERENT DATES
Replies
1
Views
137
SamBones
SamBones
maccten2000
  • Locked
  • Question
Parsing Date
Replies
0
Views
80
maccten2000
maccten2000
JCV
  • Locked
  • Question
Date of last Table update
Replies
0
Views
74
JCV
JCV

Part and Inventory Search

Sponsor

Back
Top