SQL date problem

[Guest]

What are you on about "storing dates as strings"?

OP said clearly it is a DateTime field in the Database.

This is getting super-confused.

The original "problem" was about selecting records from a table.

The conversion from any type of [date]presentation should be answered as pertaining to the parameters of that query.

The OP never asked about storing the records to be queried, that was patted down as i read it.

I feel like a StackOverflow member now 

[mvanrijnen 123]

29 minutes ago, Dany Marmur said:

What are you on about "storing dates as strings"?

OP said clearly it is a DateTime field in the Database.

This is getting super-confused.

The original "problem" was about selecting records from a table.

The conversion from any type of [date]presentation should be answered as pertaining to the parameters of that query.

The OP never asked about storing the records to be queried, that was patted down as i read it.

I feel like a StackOverflow member now 

yes, you'r right, i think it's because this:

Quote

 

>>> DateTimeToStr(FileInfo.TimeStamp));  >>> this to tree > to  DB
 

 

i got cought up in that.

So what i can see is that intenral in his code he's storing the dates as strings, got a little bit mixed up with the DB,

 

easy, easy, easy, take a breath.

 

Edited October 19, 2021 by mvanrijnen