MobileRead Forums - View Single Post

carmenchu · 10-10-2019, 03:34 PM

Hello! I would be very grateful for some help in this:

I have a custom colum in my database, of type TEXT, where I have been manually entering the 'year of creation' of each book.

Now, I would like to create another custom colum, of tipe DATE, and fill it with values from the first colum, putting the day and month to 01/01, i.e.
value -> 01/01/{imported value}

Is there some way (command line/plugin...) to do such a thing?
I suspect that the trouble is in the types of data. It easy to convert a DATA value to a text string. But, is it possible to 'make' a DATA value by concatening text strings and converting?
If the answer is 'no', I would appreciate it nonetheless...

10-10-2019, 03:34 PM	#1
carmenchu Groupie Posts: 193 Karma: 266070 Join Date: Dec 2010 Location: Spain Device: Win10,Win11,Ubuntu,PockbookLux44	Help, please: column type Hello! I would be very grateful for some help in this: I have a custom colum in my database, of type TEXT, where I have been manually entering the 'year of creation' of each book. Now, I would like to create another custom colum, of tipe DATE, and fill it with values from the first colum, putting the day and month to 01/01, i.e. value -> 01/01/{imported value} Is there some way (command line/plugin...) to do such a thing? I suspect that the trouble is in the types of data. It easy to convert a DATA value to a text string. But, is it possible to 'make' a DATA value by concatening text strings and converting? If the answer is 'no', I would appreciate it nonetheless...