Jump to content
limelect

SQL date problem

Recommended Posts

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 :classic_sad:

Share this post


Link to post
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 :classic_sad:

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 by mvanrijnen
  • Like 1

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×