Getting current date/time Mac OS total seconds

[Mr. Bart Pietercil]

Hi jda,


I think this is what you are after


SUBSTR( str, pos [,len] )

Returns substring len characters long from string str, starting at  
position pos. If parameter len is not specified then returns  
substring from string strm starting from position pos.

SELECT SUBSTRING(‘Valentina’,6,4);
=> ‘tina’
SELECT SUBSTRING(‘Valentina’,2);
=> ‘alentina’

More functions to be found here:

<http://www.valentina-db.com/dokuwiki/doku.php? 
id=paradigma:public:en:documentation:vsql:reference:expr:functions:strin 
g>



hth

Bart


On 21-dec-07, at 21:14, jda wrote:

>>
>>
>> Valentina SQL automatically convert types when needed
>>
>> Just recall how works Table Methods.
>>
>
> Hi Ruslan,
>
> Yes, thanks, I see.
>
> One last thing I need -- maybe I can't do this with Valentina SQL  
> alone.
>
> The date is embedded in a varchar field like this
>
> some text... + chr(9) +10 digit date in seconds + chr(9) + more  
> text...
>
> I need to be able to extract the 10 digit date. In RB I could use  
> NthField to do this, or split the string into an array. But in  
> Valentina?...
>
> Jon
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina